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

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

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.

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

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.

N40934Southern Style Equipment LLC · Sulphur, LABuilt 1974 · S/N 32-7440071 N4095YLakeland Air 6 LLC · Lakeland, FLBuilt 1981 · S/N 31-8152181 N4096WCruisers Pacific LLC · Discovery Bay, CABuilt 1967 · S/N 32-40159 N4097KSwag Aviation LLC · Labelle, FLBuilt 1981 · S/N 31-8152191 N4098AJaa Holdings LLC · Springfield, ILBuilt 1981 · S/N 31-8152200 N4098RLawler Christy · Livingston, MTBuilt 1968 · S/N 32-40406 N40992Awmr LLC · Conroe, TXBuilt 1982 · S/N 31-8252045 N4099WWilde Stephen · Elverta, CAS/N 32-40162 N409AKHenderson Kim · Everett, WABuilt 1998 · S/N 3257072 N40CACharley Alpha LLC · Umatilla, FLBuilt 1980 · S/N 31-8012082 N40CVDos Vidas Services Inc · Seabrook, TXBuilt 1979 · S/N 31-7912124 N40EWWka Incorporated · Kendallville, INBuilt 1993 · S/N 27-0164 N40HPRock Communications LLC · Rock Hill, SCBuilt 2000 · S/N 4636264 N40JEReddy Subash C · Huntingdon Valley, PABuilt 1993 · S/N 27-0161 N40LHSale Reported · Prineville, ORSale reported, pending cancellationBuilt 1994 · S/N 27-0178 N40LWMorgan Aviation LLC · Oak Harbor, WABuilt 1975 · S/N 27-7554146 N40RZTwin Trails LLC · Draper, UTBuilt 1995 · S/N 4636009 N40TBTowe Wyley · Rogersville, MOBuilt 1997 · S/N 27-0232 N40ZMArmour Anthony E · Ringgold, GABuilt 1993 · S/N 27-0169 N4101BBerry Larry A · Bryan, TXBuilt 1974 · S/N 74-31106 N4101NGateway Of Sturgis LLC · Sturgis, MIBuilt 1981 · S/N 31-8252010 N4101RMclean David L · Nashville, TNBuilt 1968 · S/N 32-40489 N4102JCarto Flight Inc · Willoughby, OHBuilt 1981 · S/N 31-8152158 N4102RDudzinski James · Reno, NVBuilt 1968 · S/N 32-40418 N4102WSkirzynski Eric N · Meridian, IDBuilt 1967 · S/N 32-40165 N4102ZValley Airways Inc · Scottsbluff, NEBuilt 1981 · S/N 31-8212009 N4103WBean Sheila L · San Antonio, TXBuilt 1967 · S/N 32-40166 N4104KStar Marianas Aviation School Inc · Tinian, MPBuilt 1982 · S/N 31-8252018 N4105DGrant Aviation Inc · Anchorage, AKFirst renewal noticeBuilt 1981 · S/N 31-8252027 N4105RWertz Travis F · Richland Center, WIBuilt 1968 · S/N 32-40424 N4106FRocket Air Charter LLC · Melbourne, FLBuilt 1982 · S/N 31-8252034 N4107QGrant Aviation Inc · Anchorage, AKBuilt 1982 · S/N 31-8253008 N4107RSatnews Publishers Inc · Carson City, NVBuilt 1967 · S/N 32-40426 N4108WArrow Ventures Inc · Lake Preston, SDS/N 32-40171 N4109AMarc Inc · Bolton, MSBuilt 1970 · S/N 27-4459 N4109FB&C Blue Sky II LLC · Augusta, GABuilt 1982 · S/N 31-8212027 N410CPNomad Flight One Inc · Clearwater, FLBuilt 2003 · S/N 3255010 N410RABradley Aviation Group LLC · Van Nuys, CABuilt 1979 · S/N 27-7954097 N410TAJ Azteca Express Inc · Eagle Pass, TXBuilt 2003 · S/N T20608410 N41101Mcgregor Daniel A · Denali National Pk, AKS/N 31-8252066 N4110WRaschio Ernesto G · Doral, FLBuilt 1967 · S/N 32-40173 N4112EYr-Aircraft Leasing LLC · Bethel, AKBuilt 1982 · S/N 31-8353005 N4112KGriffin Robert G Trustee · Anchorage, AKBuilt 1982 · S/N 31-8353006 N4112RLangenegger Glenn · Burns, KSBuilt 1968 · S/N 32-40431 N4112WLian Ian · Beaumont, TXBuilt 1967 · S/N 32-40175 N4113BRishell Charles G · Columbia, MDBuilt 1974 · S/N 74-32-145 N41142Waters Agricultural Laboratories Inc · Camilla, GABuilt 1983 · S/N 31-8352034 N4114PChieftain 4114p LLC · Lewes, DEBuilt 1982 · S/N 31-8252069 N4114WWilliams Frank J · Mendon, MABuilt 1967 · S/N 32-40177 N41152Mb Stedman Airplane LLC · Marble Falls, TXBuilt 1993 · S/N 27-0155

Back to AD 84-19-03 R1