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.

N2873AAndelin Sheila P · Newport Beach, CABuilt 1953 · S/N 30073 N2873YMorris Ben M · Albany, GABuilt 1962 · S/N 18253873 N2874EMoutafian Adom · Los Gatos, CAS/N 21062773 N2874KWashburn Kent F · Grants Pass, ORBuilt 1979 · S/N 18053110 N2876FJohnston Natalie R · Edgewood, TXBuilt 1966 · S/N 18256976 N2876YForbes Richard L · Plano, TXBuilt 1962 · S/N 18253876 N2877ADutremble Donald L · Amherst, NHBuilt 1953 · S/N 30077 N2877YBrumback Recreation LLC · Bluffdale, UTBuilt 1962 · S/N 18253877 N2878AAero Garage Inc · Fort Myers, FLS/N 30078 N2879FMinich Sophie R · Anchorage, AKS/N 18256979 N2879KTwo Niner Kilo LLC · Seattle, WABuilt 1979 · S/N 18053115 N287CACivil Air Patrol · Maxwell Afb, ALBuilt 2024 · S/N 18283264 N287TCAiv Con Inc · Charlevoix, MIBuilt 1969 · S/N 18260183 N2880RPhelps Thomas J · Orem, UTBuilt 1967 · S/N 18258480 N2880YRegistered aircraftBuilt 1962 · S/N 18253880 N2881FAirplanes Over Niagara LLC · Lewiston, NYBuilt 1966 · S/N 18256981 N2882YVx Aviation LLC · Palisade, COBuilt 1962 · S/N 18253882 N2883RCallegari Sergio P · Reno, NVBuilt 1967 · S/N 18258483 N2884ADowns M Todd · De Leon, TXFirst renewal noticeBuilt 1953 · S/N 30084 N2884FTurner Michael B · Covington, TNBuilt 1966 · S/N 18256984 N2884KJ Robert Finley And Associates Inc · Mountain Home, ARBuilt 1979 · S/N 18053118 N2884RSalem Coastal Enterprises LLC · Elizabeth City, NCFirst renewal noticeBuilt 1967 · S/N 18258484 N2884YTri-Aviation Inc · Amarillo, TXBuilt 1962 · S/N 18253884 N2885YMiner Bradford Aviation LLC · Spanish Fork, UTS/N 18253885 N2886FWeldon Larry W · Titusville, PABuilt 1966 · S/N 18256986 N2887RNaylor Michael Scott · Modesto, CABuilt 1967 · S/N 18258487 N2888ESterett Terry Alan Jr · New Port Richey, FLBuilt 1982 · S/N 18268218 N2888FLynch Neil E · Ceresco, MIBuilt 1966 · S/N 18256988 N2888KBooth William R Jr · Sterling, AKBuilt 1979 · S/N 18053119 N2889EWesellhigh LLC · West End, NCBuilt 1982 · S/N 18268219 N2889FLander Kirt E · Kingman, AZBuilt 1966 · S/N 18256989 N2889RAircraft Structural Repair Inc · Hamilton, MTBuilt 1967 · S/N 18258489 N2889YJust Jump Skydiving LLC · Laurens, NYBuilt 1962 · S/N 18253889 N288BTValiair Ltd Co Trustee · Casper, WYBuilt 2005 · S/N 18281607 N288CPCivil Air Patrol · Maxwell Afb, ALBuilt 2007 · S/N 18281988 N288LSVacendak William A · Wasilla, AKS/N 32953 N288LTGlatczak Jerome · Schofield, WIBuilt 1963 · S/N 18255038 N288MCTomanec Jean · Victoria, TXBuilt 2002 · S/N 18281110 N288RWNortheastern Assets Holdings LLC · Dover, NHS/N 18267369 N288SPGlass Cockpit Aviation Inc · San Juan, PRBuilt 2006 · S/N 20608282 N288TMSlaba Mark E · Arcadia, FLBuilt 1967 · S/N 18258263 N2890FAeolus Aviation LLC · Franklin, TNBuilt 1966 · S/N 18256990 N2890YWomble Warren G · Chapel Hill, NCBuilt 1962 · S/N 18253890 N2891ARegistered aircraftBuilt 1953 · S/N 30091 N2891FBayshore Properties LLC · Hagerstown, MDBuilt 1966 · S/N 18256991 N2892FSpeedtape Airways LLC · Williamson, GABuilt 1966 · S/N 18256992 N2892RBuenafe Constance Ann · Santa Fe, NMBuilt 1967 · S/N 18258492 N2895AAirspace Aerial Media LLC · Saint Louis, MOBuilt 1953 · S/N 30095 N2895FWilson Paul D · Peachtree Corners, GABuilt 1966 · S/N 18256995 N2896FEvans Gene · Center, MOBuilt 1966 · S/N 18256996

Back to AD 84-10-01 R1