Registered aircraft · 4,243

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

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:89-24-01-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:89-24-01-R1') ORDER BY n_number

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:89-24-01-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:89-24-01-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.

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:89-24-01-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:89-24-01-R1')
ORDER BY n_number

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

N216LBBail Air LLC · Port Saint Lucie, FLBuilt 1974 · S/N 414-0545 N216LHHackbarth Lee A · Bend, ORBuilt 1981 · S/N U20606057 N2181SGreer Kenneth R · Pittsburgh, PABuilt 1975 · S/N 21061142 N218CCSotally Tober LLC · Wilmington, DEBuilt 1979 · S/N 21063297 N218CFLevel 200 LLC · Charlottesville, VABuilt 1980 · S/N 340A0989 N21BCAmelse Troy · Chippewa Falls, WIBuilt 1980 · S/N EA-65 N21BESpecialized Helicopter Training LLC · Middleton, IDBuilt 1979 · S/N P21000456 N21CTFerreira Douglas B Trustee · Chico, CABuilt 1978 · S/N P21000021 N21KDMrd Aviation LLC · Windsor, COBuilt 1979 · S/N 414A0439 N21KRNorcon Enterprises Inc · Amarillo, TXBuilt 1979 · S/N P21000285 N21LTMission Flight · El Monte, CABuilt 1979 · S/N P21000216 N21NPRossi Michael · Ronan, MTBuilt 1978 · S/N TK-77 N21WUDallas Aero & Sales LLC · Poplar, MTBuilt 1979 · S/N 421C0650 N2201UChrisara Investments LLC · Carson City, NVBuilt 1997 · S/N EA-601 N220DPMyrick Richard Leon · Williamson, GABuilt 1966 · S/N 380 N220GDJoseph M De Lecce Trustee · Prather, CAS/N 414A0459 N220TJJaco Oil Co · Bakersfield, CAS/N 21063139 N220WBWells Propane Inc · Wells, NVBuilt 1974 · S/N 210-60194 N22121Registration Pending · Georgetown, TXRegistration pendingBuilt 1972 · S/N 21059711 N221PPLive Pilot Training LLC · Ankeny, IABuilt 1987 · S/N 46-08064 N221TBSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1985 · S/N 46-8508061 N22232Engeseth James Jr · Parker, COBuilt 1972 · S/N 21059730 N2226LSlyngstad Todd · San Jose, CABuilt 1999 · S/N EA-640 N2229SKey Lime Consultants LLC · Wilmington, DEBuilt 1976 · S/N 21061174 N222AXGraven Timothy G · Foristell, MOBuilt 1970 · S/N 414-0078 N222BJFlight Smith LLC · Orem, UTBuilt 1972 · S/N 414-0264 N222DKVestal Randy L · Darien, GABuilt 1982 · S/N 25-0721 N222FGSkytravel LLC · Victoria, TXBuilt 1981 · S/N 414A0823 N222GSLandau Management Services Inc · Topanga, CABuilt 1981 · S/N TJ384 N222HCMuddflyers LLC · Woodbridge, VABuilt 1981 · S/N EA-259 N222LSLj Bickford Companies LLC · Wasilla, AKBuilt 1972 · S/N U206-01751 N222MDElx Aviation LLC · Hartford, MIBuilt 1974 · S/N 310Q1013 N222PLAnderas Per R · Green Bay, WIS/N 414A0521 N222PRFlying South LLC · Wilmington, DEBuilt 1973 · S/N 4140384 N222RDAviation Consultants Inc · San Luis Obispo, CABuilt 1977 · S/N 340A-0366 N222RMKelco LLC · Helena, MTBuilt 1971 · S/N 414-0168 N222SGPacific Aviation Aircraft Management Inc · Fresno, CAS/N 210-64410 N222STEau Claire Aviation LLC · Eau Claire, WIBuilt 1976 · S/N 310R0679 N222SVEllsworth Jason W · Hamilton, MTS/N 414-0164 N222UWFlyin In Style LLC · Greenwood, MSBuilt 1979 · S/N EA-49 N2235SN2235s LLC · Overland Park, KSBuilt 1976 · S/N 21061180 N223KWMedic Choppers LLC · Springdale, ARS/N EA-382 N223PBHyannis Air Service Inc · Hyannis, MABuilt 1979 · S/N 402C0105 N223SBAdams Derek · Lexington, MABuilt 1981 · S/N TJ-339 N223SCSurdex Corp · Chesterfield, MOBuilt 1973 · S/N U20601999 N22459Hatch Leasing Company LLC · Flagstaff, AZBuilt 1972 · S/N 21059754 N2247SCarnes Andrew P · Wichita Falls, TXBuilt 1976 · S/N 21061191 N2249SDlw Flight Services LLC · Waterloo, ILBuilt 1976 · S/N 21061193 N224DRN224dr LLC · Morristown, NJBuilt 2000 · S/N EA-660 N224KAChambers William Melvin Jr · Azle, TXBuilt 1979 · S/N 21063812

Back to AD 89-24-01 R1