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.

N316SFDoc Aviation LLC · Ponca City, OKBuilt 1964 · S/N 18255668 N3170GHolbrook Maslen · Caldwell, IDS/N 7590 N3170QRenfrow Denny · Kelseyville, CABuilt 1967 · S/N 18258170 N3170UHarrison Brian C · New London, OHBuilt 1962 · S/N 18254570 N3170YStillson John L · Rock Rapids, IAS/N 18254170 N3171CLand Sea & Air Inc · North Mankato, MNBuilt 1954 · S/N 30970 N3171DJohnson Donald B · Lino Lakes, MNBuilt 1955 · S/N 31969 N3171FRockin Rt LLC · Smithfield, UTS/N 18257271 N3171YDj Aviation LLC · Newburgh, INBuilt 1962 · S/N 18254171 N3172EKruchten Larry A · Scottsdale, AZBuilt 1982 · S/N 18268237 N3172SSterling Flyers LLC · Lehi, UTS/N 18255672 N3172YPeters Barry S · Montague, CABuilt 1962 · S/N 18254172 N3173CMcgaha Justin L · Hooker, OKS/N 30972 N3173FJames Pearl LLC · Norfolk, VABuilt 1966 · S/N 18257273 N3173SCortese Farm And Ranch Inc · Fort Sumner, NMFirst renewal noticeBuilt 1964 · S/N 18255673 N3174DRegistered aircraftBuilt 1955 · S/N 31972 N3174FRozier Harold H Jr · Blackshear, GABuilt 1966 · S/N 18257274 N3174QMclaughlin Daniel R · Xenia, OHBuilt 1967 · S/N 18258174 N3174UMorris Debbie L · Columbus, GABuilt 1963 · S/N 18254574 N3175CClay Jason I · Imperial Beach, CABuilt 1954 · S/N 30974 N3175FEstes Bernard R · Bumpass, VABuilt 1966 · S/N 18257275 N3175UKeller Richard J · Martinsburg, WVBuilt 1963 · S/N 18254575 N3175YPittman Joel C · Apple Valley, CABuilt 1962 · S/N 18254175 N3176CYoung Thomas O · Battle Ground, WABuilt 1954 · S/N 30975 N3176YThomas Steven Dale · Monticello, ILS/N 18254176 N3177CRsb Properties LLC · Lewes, DEBuilt 1978 · S/N R18200248 N3177SFreeman William R · Lenexa, KSBuilt 1964 · S/N 18255677 N3177YSkyknights Sport Parachute Club Inc · East Troy, WIFirst renewal noticeBuilt 1962 · S/N 18254177 N3178DSager Kenneth A · Hummelstown, PABuilt 1955 · S/N 31976 N3178YNiles Air LLC · Concord, NCBuilt 1962 · S/N 18254178 N3179CWoods Kevin M · Spokane, WABuilt 1954 · S/N 30978 N3179DPreiss James M Trustee · Poplar Grove, ILBuilt 1955 · S/N 31977 N3179FMoran Peter J · Como, MSBuilt 1966 · S/N 18257279 N3179YWolstein Joe M · Bigfork, MTBuilt 1962 · S/N 18254179 N317HDHardrock Drilling LLC · Francesville, INBuilt 2026 · S/N 18283339 N317KAWycka Michelle Sarah · Stayton, ORS/N 18254317 N31803Mekker Mark S · Getzville, NYS/N 18052420 N3180DKleimer Steve · Bozeman, MTBuilt 1955 · S/N 31978 N3180QA & L Aircraft Holding LLC · Miami Springs, FLBuilt 1967 · S/N 18258180 N3180RThomas Lance E Trustee · Mesa, AZBuilt 1967 · S/N 18258580 N3180UBasan Oasis LLC · Santa Teresa, NMBuilt 1963 · S/N 18254580 N3180YWalker Jim · Lovell, WYBuilt 1962 · S/N 18254180 N3181CFour Boys Aviation LLC · Madison, MSFirst renewal noticeBuilt 1954 · S/N 30980 N3181SWood David M · Purcellville, VABuilt 1964 · S/N 18255681 N3182DHanft Thomas A · Oakhurst, CABuilt 1955 · S/N 31980 N3182QMagnusson Ralph L · Wyoming, MNBuilt 1967 · S/N 18258182 N3182RSeven Hills Sky Divers Inc · Madison, WIBuilt 1967 · S/N 18258582 N3182SRyan Aviation Management LLC · Palm Coast, FLBuilt 1964 · S/N 18255646 N3182UGarcia-Martinez Jose Victor · Birmingham, ALBuilt 1963 · S/N 18254582 N3182YHeckethorn Philipp · Baker, NVBuilt 1962 · S/N 18254182

Back to AD 84-10-01 R1