OpenAirDocs.org
AD 84-19-03 R1

Registered aircraft · 5,075

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:84-19-03-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:84-19-03-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.

N924TFRegistered aircraftBuilt 1996 · S/N 27-0218N9250PBas Part Sales LLC · Greeley, COBuilt 1967 · S/N 24-4747N9251PSalori Aviation LLC · Centralia, MOBuilt 1967 · S/N 24-4749N9252POsipov Yuri A · Lomita, CABuilt 1967 · S/N 24-4750N9253CJetstream LLC · River Forest, ILBuilt 1995 · S/N 4622183N9253PConway Brandon · Springtown, TXBuilt 1967 · S/N 24-4751N9255PSalvia Michael · Farmington Hills, MIBuilt 1968 · S/N 24-4754N9257NJohn Bowman Inc · Fountain, COBuilt 1995 · S/N 4636006N9258PCessna 79432 LLC · Missoula, MTBuilt 1968 · S/N 24-4757N9259PChiarini Joshua · Cranston, RIBuilt 1968 · S/N 24-4758N925BFSandin Robyn · Mc Donald, TNBuilt 2000 · S/N T20608232N925DBHawk2lane LLC · Newark, DEBuilt 2005 · S/N T18208366N925TCJarvis Bradley A · North Port, FLBuilt 1981 · S/N 32R-8129013N9260PRichter Scott J · Eden Prairie, MNBuilt 1996 · S/N 4636044N9262GChampion Med LLC · Dover, DEBuilt 1995 · S/N 4636017N9262PReliant Aeroworks LLC · Sanger, TXBuilt 1968 · S/N 24-4761N9262YTwin Star Montana LLC · Kalispell, MTBuilt 1984 · S/N 31P-8414033N9263KCrook Michael J · Paradise, UTBuilt 1976 · S/N 32R-7680205N9263PWhitacre John B III · Waynesburg, OHBuilt 1968 · S/N 24-4762N9264PBeil Richard P Trustee · Caroline, WIBuilt 1968 · S/N 24-4763N9267PNickravesh Niknam J · San Jose, CABuilt 1968 · S/N 24-4767N9268PAts Inc · Chicago, ILBuilt 1968 · S/N 24-4768N926HBAwmr LLC · Conroe, TXBuilt 1975 · S/N 317552007N9270PPenn Landmark Corp · Pinehurst, NCS/N 24-4770N92714Registered aircraftBuilt 1996 · S/N 4636042N92728Washington International Aviation LLC · Washington, DCBuilt 1996 · S/N 4636050N9272PH&R Aircraft LLC · Kansas City, MOBuilt 1968 · S/N 24-4772N9272YIal Corp · Lewes, DEBuilt 1984 · S/N 31P-8414039N9274PMurray John F · Crystal Lake, ILBuilt 1968 · S/N 24-4774N92765N92765 Inc Trustee · Wilmington, DEBuilt 1996 · S/N 4636070N9276PHansen Stephen J · Redmond, WAS/N 24-4776N9279PArdis Mitchell Farm LLC · Winnsboro, TXBuilt 1968 · S/N 24-4780N927DMGoat Rancho LLC · Euless, TXS/N 32-40225N927PTReds Asset Managers LLC · Pottsville, PABuilt 1976 · S/N 27-7754008N9280KN9280k LLC · Miami, FLBuilt 1997 · S/N 4636109N92811Stephen Beazley Builders Inc · Evans, GABuilt 1996 · S/N 4636076N9281BClear View Inc · Fort Smith, ARBuilt 1996 · S/N 4636074N92821Aerinova Inc · Mattoon, ILBuilt 1997 · S/N 4636081N92835Ruff Aviation LLC · Asheville, NCBuilt 1997 · S/N 4636097N9284X84x Leasing LLC · Idaho Falls, IDBuilt 1997 · S/N 4636087N9285QJrb Aviation Ltd · Jasper, GABuilt 1997 · S/N 3257023N92884Bas Part Sales LLC · Greeley, COBuilt 1997 · S/N 4636107N9288PLivingston Jerry D · Wichita, KSBuilt 1968 · S/N 24-4788N9289PSvetlik Ludvik Julius · Victoria, TXS/N 24-4789N928HLJ & M Sales & Leasing LLC · Abingdon, ILS/N T20608066N9292NN9292n LLC · Valdosta, GABuilt 1997 · S/N 3257008N9292PRegistered aircraftBuilt 1968 · S/N 24-4791N9292YWeisend Chad M · Logansport, INBuilt 1969 · S/N 31-387N9293PCenterline Holdings Inc · Camden, DEBuilt 1968 · S/N 24-4792N9293YBecker Ryan · Sheldon, IABuilt 1985 · S/N 32R-8629004
Back to AD 84-19-03 R1