AD 90-04-06 R1

Registered aircraft · 68,377

Registered aircraft whose airframe or engine model this AD names, by N-number. Matched by model only, so check each against the AD’s applicability.

Query with SQL
duckdb -csv -c "SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state
  FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
  WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:90-04-06-R1')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:90-04-06-R1')
  ORDER BY n_number"

Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.

N917WTStamsta David T · Ennis, MTBuilt 2003 · S/N 00-1170N917XKirkegaard Lewis J · Grand Junction, COBuilt 2012 · S/N 7375N9180TMcguire Michael D · Lake Stevens, WABuilt 1996 · S/N 3250N91813Fallbrook Fly Girl LLC · Lakeside, ORBuilt 1973 · S/N 17261515N9181CFord Winston · Tyrone, GABuilt 1992 · S/N 58N9181SFhs Aero Co Ltd · Olathe, KSBuilt 1976 · S/N M-1798N91823Perra John James Trustee · Gardnerville, NVBuilt 1973 · S/N 17261516N9182AAlpha Aviation Holdings Group LLC · Raleigh, NCBuilt 1982 · S/N 38-82A0102N9182HMouton Charles · Gladewater, TXBuilt 1975 · S/N 17265997N9182JTremblay Christopher A · Albion, MEBuilt 1966 · S/N 28-3250N9182KRoth Howard R · Mott, NDBuilt 1976 · S/N 28-7625169N9182SBig Bend Community College · Moses Lake, WABuilt 1975 · S/N MB-786N9182WMoyer Aviation Inc · Tobyhanna, PABuilt 1989 · S/N 2841130N91834Skylink Xpress Inc · San Bernardino, CABuilt 1989 · S/N 2841141N9183KKoinzan Flying Service Inc · Elgin, NEBuilt 1996 · S/N 110N9183SToole William Barry · Goochland, VABuilt 1976 · S/N M-1802N9183VBerrong Jimmy L · Dahlonega, GABuilt 1969 · S/N 690039N9184HBaker Eric D · Isanti, MNS/N 77-133N9184LKindred Champ LLC · Hickson, NDBuilt 1971 · S/N 327-72N9184VCloud Distributing LLC · Austin, TXBuilt 1969 · S/N 690036N9184XContinental Title Trust LLC Trustee · Wichita, KSBuilt 1966 · S/N 30-1041N91854Sjostedt Brad D · Cordova, AKS/N 357-72N9185HFlyit LLC · Washougal, WABuilt 1975 · S/N 17265999N9185JRatcliff Dale A · Granville, OHBuilt 1966 · S/N 28-3253N9185LKnighten Ammon J · Gakona, AKBuilt 1971 · S/N 324-72N9185SGrushkin Jon S · Mazon, ILBuilt 1976 · S/N M-1799N9185ZAirborne Tactical Solutions LLC · Mooresville, NCBuilt 1966 · S/N 1228N91862Aire Services LLC · Barrigada, GUBuilt 1973 · S/N 17261519N9186DEckels Daniel R · Centerburg, OHBuilt 1958 · S/N 22-6244N9186KMock Joseph R · Huntsville, TXBuilt 1976 · S/N 28-7615181N9186LAshby Darrell T · Elko, MNBuilt 1971 · S/N 231-72N9186MBlazer Aviation LLC · Charlotte, NCBuilt 1992 · S/N 10122N9186SHigh Flyin LLC · Canton, MSBuilt 1976 · S/N M-1805N9187LGardner James Jr · El Campo, TXBuilt 1971 · S/N 328-72N9187MPhillips Tim · Blair, OKBuilt 2001 · S/N 3418N9187SCarr Gary · Crestwood, ILBuilt 1976 · S/N MB-790N9188Grant James B · Fairview, ORBuilt 1929 · S/N 1158N9188GAircraft Management Services Inc · Milton, FLBuilt 1979 · S/N 17273625N9188JBooth Emmett W · Waitsburg, WAS/N 28-3256N9188LSodowsky Jim L · Ponca City, OKBuilt 1971 · S/N 814-72N9188SVanommeren Matthew · Uniondale, NYBuilt 1976 · S/N M-1803N9188VValiair Limited Co Trustee · Casper, WYBuilt 1969 · S/N 690049N9188YGrove Randy L · Bellefonte, PABuilt 2012 · S/N GR-2N9189HPendergrass Aviation Inc · Demopolis, ALBuilt 1975 · S/N 17266002N9189JMileski William J · Ledyard, CTBuilt 1966 · S/N 28-3257N9189TBunselmeier Donald W · Delta Junction, AKBuilt 1979 · S/N 18-8009020N9189VEl Capitan LLC · Thornton, COBuilt 1969 · S/N 690040N918AGPeregrine Howard Aeroflight Owner LLC · New Orleans, LABuilt 2025 · S/N 2881947N918BCMiesler Hans U · Penrose, COS/N 0001N918CPCivil Air Patrol Inc · Maxwell Afb, ALBuilt 1999 · S/N 172S8338
Back to AD 90-04-06 R1