Skip to content

Registered aircraft · 20,483

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-10-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:84-10-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:84-10-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:84-10-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:84-10-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:84-10-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.

N3584UMagic Valley Aero Club Inc · Twin Falls, IDBuilt 1963 · S/N 18254984 N3584YHassler John Cameron · East Helena, MTBuilt 1962 · S/N 18254484 N35851Northwest Passage LLC · Anchorage, AKS/N U20602757 N35859Hooper Ranch LLC · Elko, NVBuilt 1975 · S/N U20602763 N3585FArikara Properties LLC · Beulah, NDBuilt 1966 · S/N 18257585 N3585UNieder Brady W · Anchorage, AKBuilt 1963 · S/N 18254985 N3585YSeemann Brian N · Lake Havasu City, AZBuilt 1963 · S/N 18254485 N35868Spence Flight Service LLC · Enterprise, ORBuilt 1973 · S/N U20602107 N3586FRegistration Pending · Phoenix, AZRegistration pendingBuilt 1966 · S/N 18257586 N35877Turbine Conversions Ltd · Nunica, MIBuilt 1975 · S/N U20602777 N3587FStout Colt W · Bosque Farms, NMBuilt 1966 · S/N 18257587 N35883Sasquatch Alaska Adventure Co LLC · Fritz Creek, AKBuilt 1975 · S/N U20602779 N35889Torgerson Management Inc · Turtle Lake, WIBuilt 1975 · S/N U20602783 N3588FBlue Eagle Aviation LLC · Edmond, OKS/N 18257588 N3588UBattles Danny C · Burns Flat, OKBuilt 1963 · S/N 18254988 N3589FInmon Glen A · Pontotoc, MSBuilt 1966 · S/N 18257589 N3589YHmb Aviation LLC · St George, UTS/N 18254489 N358CBHurn Farm Enterprises LLC · Grand Beach, MIBuilt 2025 · S/N 18283314 N358CPCivil Air Patrol · Maxwell Afb, ALBuilt 2005 · S/N 18281510 N358MERibelin Holdings LLC · Yacolt, WABuilt 2000 · S/N 18280847 N35909Flight1 Hsw LLC · Norwood, COBuilt 1975 · S/N U20602792 N3590YAlexander Macy Nix · Mineral Wells, TXBuilt 1963 · S/N 18254490 N3592FArey Peter W · Great Falls, VABuilt 1966 · S/N 18257592 N3592YArcher Donald B · Artesia, NMBuilt 1962 · S/N 18254492 N35932Tmzk Holdings LLC-1 · North Fort Myers, FLBuilt 1975 · S/N U20602808 N35937Glaser Don E DBA · Willow, AKFirst renewal noticeBuilt 1975 · S/N U20602812 N3593UBdg Holdings Inc · Kingston, PABuilt 1969 · S/N 18259866 N35945Illinois Department Of Transportation · Springfield, ILBuilt 1975 · S/N U20602819 N35947Continental Construction Inc · Alpine, WYBuilt 1975 · S/N U20602821 N3594FFirst Flight Corp · San Diego, CABuilt 1966 · S/N 18257594 N35952Johnson Deborah K · Fairbanks, AKBuilt 1974 · S/N U20602825 N35957Cortez Flying Service Inc · Cortez, COBuilt 1975 · S/N U20602829 N3595UBrinkman Eric · Phoenix, AZBuilt 1963 · S/N 18254995 N35962Barker Aviation LLC · Spearfish, SDBuilt 1975 · S/N U20602833 N3596YHeintz Ludwig C · Covington, LABuilt 1962 · S/N 18254496 N3597FLivesay John · Pana, ILBuilt 1966 · S/N 18257597 N3597YCraig & Craig LLC · Merrillville, INS/N 18254497 N3598UDunn Mark · Visalia, CABuilt 1963 · S/N 18254998 N3599YLooker Daniel M · Ferndale, WABuilt 1962 · S/N 18254499 N359BDHoffman Brian T · Flower Mound, TXBuilt 1980 · S/N 21064054 N359CPCivil Air Patrol · Maxwell Afb, ALBuilt 2005 · S/N 18281535 N359DACessna 359da LLC · Warsaw, VABuilt 1979 · S/N U20605240 N359DBKiehne Gary L · Springerville, AZBuilt 1960 · S/N 18253026 N359TWDouble Bogey Aviation LLC · Midland, TXBuilt 2004 · S/N 18281477 N35BHSkylane Ventures LLC · Charlotte, NCBuilt 1979 · S/N R18201050 N35BRSlaughter Robert H · Spring, TXBuilt 1975 · S/N 18264274 N35CFGilbert David · Othello, WABuilt 1972 · S/N 18261235 N35GElias 48 LLC · Morristown, AZS/N R18201785 N35GVMartin Scott W · Bowie, MDBuilt 1976 · S/N 18264828 N35MQFly Planet LLC · Kalispell, MTBuilt 1973 · S/N 18262505

Back to AD 84-10-01 R1