AD 75-06-01

Registered aircraft · 2,832

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:75-06-01')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:75-06-01')
  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.

N2239BBeery Milo A · Clarinda, IAS/N T41-217N223ALWin Win Aviation Inc · Wake Forest, NCBuilt 1969 · S/N 223N223CABemidji Aviation Services Inc · Bemidji, MNBuilt 1983 · S/N U-200N223EARegal Air Partners I LLC · New Iberia, LABuilt 2005 · S/N 323N223LHLelah Holdings Limited Partnership · Reno, NVBuilt 1976 · S/N B-223N223QKRovey Jason · Wickenburg, AZBuilt 2017 · S/N 100-0223N2243JR & S Aviation LLC · Corning, ARBuilt 1996 · S/N T41-221N224CCRanger Aviation LLC · Houston, TXS/N LJ-1218N224SAIkhana Aircraft Holdings LLC · Murrieta, CABuilt 1969 · S/N 247N2251QSabo John W · Spicewood, TXBuilt 1997 · S/N EA-604N2254LPhoenix Equipment Lc · Nickerson, KSFirst renewal noticeBuilt 1985 · S/N 400-0611N225CATvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1981 · S/N 31T-8104024N225JCJetcruzer International LLC · Ontario, CABuilt 1997 · S/N 002N225MAAerial Services Inc · Cedar Falls, IABuilt 2001 · S/N 4697106N226DRTechnical Education Services Inc · Virginia Beach, VABuilt 1967 · S/N LM-14N226MDSolomon Aviation LLC · Northumberland, PAS/N 88N227AVUas Transervices Inc · Boca Raton, FLBuilt 1984 · S/N U-227N227DCEllen Vineyards Inc · Sanger, CABuilt 1979 · S/N LJ876N227MFMeragals LLC · Evergreen, COBuilt 2003 · S/N 502N227WWFayard Enterprises LLC · Wake Forest, NCBuilt 1966 · S/N 27N2281ADuck Hill Air Service LLC · Grenada, MSBuilt 1997 · S/N T15-034N228AJTriton Airplane Leasing LLC · Wilmington, DEBuilt 1999 · S/N FL-245N228MEWhite & Stradley Pllc · Raleigh, NCS/N 49N228VJAyfu LLC · Kalispell, MTBuilt 2022 · S/N 100-0306N2292HNorth Florida Ag Services Inc · Lake City, FLBuilt 1999 · S/N T34-257N2297CRaviator II LLC · Dallas, TXBuilt 1997 · S/N LJ-1497N229CLMcknight Thomas N · Fredericksburg, TXBuilt 2017 · S/N 100-0229N22MTHagler Air LLC · Augusta, GABuilt 1994 · S/N LJ-1368N22NDynamic Avlease Inc · Bridgewater, VABuilt 1973 · S/N LW48N22PEAdamb200 Holdings LLC · Broken Bow, OKBuilt 1994 · S/N BB-1488N23034Crop Dusters LLC · Maurice, IABuilt 1999 · S/N T34-259N2306ABlanke Jason F · Mandeville, LABuilt 1981 · S/N 400-0345N231BWN231bw LLC · Hayden, IDBuilt 2004 · S/N 600N231YVAlpine Aviation Inc · Provo, UTBuilt 1996 · S/N UE-231N233KQImagine Air Leasing LLC · Fort Lauderdale, FLBuilt 2017 · S/N 100-0233N23416Woodley Aerial Leasing LLC · Walnut, ILBuilt 1981 · S/N 301-0385N234CCDarrow Mark A Trustee · Mukilteo, WABuilt 1983 · S/N 85N234KQOld Beauty LLC · Missoula, MTS/N 100-0234N234KW405 Transportation Partners LLC · Edmond, OKBuilt 1982 · S/N BB-1065N234RGCsc Delaware Trust Co Trustee · Wilmington, DEBuilt 2003 · S/N 520N2354YUtah Department Of Transportation · Salt Lake City, UTBuilt 1998 · S/N LJ-1532N235SFScott Air LLC · Munster, INBuilt 2002 · S/N 251N23618Aerinova Aerial LLC · Mattoon, ILBuilt 1981 · S/N 400-0402N23649Abernathy Spraying Service Inc · Tipton, OKBuilt 1981 · S/N 400-0408N236ALAlpine Aviation Inc · Provo, UTBuilt 1987 · S/N U236N237KConquest Express LLC · Libertyville, ILBuilt 1994 · S/N BB-1481N237SLAlpine Aviation Inc · Provo, UTBuilt 1987 · S/N U237N237STIlluminus Aviation LLC · Chicago, ILBuilt 2005 · S/N 4697237N23813Davis Blake A · Bellevue, TXBuilt 1982 · S/N 400A-0433N238ALAlpine Aviation Inc · Provo, UTBuilt 1987 · S/N U238
Back to AD 75-06-01