Skip to content

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.

N8384CMountain Flying Adventures LLC · Missoula, MTBuilt 1976 · S/N 32R-7680105 N8384LMaring Inc · Blaine, MNBuilt 1981 · S/N 32R-8129054 N8386HSierra Aero · Carson City, NVBuilt 1981 · S/N 32R-8129067 N83894Sale Reported · Grangeville, IDSale reportedBuilt 1981 · S/N 32-8124029 N8392PVaughn Charles P · Inverness, FLBuilt 1964 · S/N 24-3652 N8393XAeroforge LLC · Crystal Lake, ILBuilt 1981 · S/N 32R-8129074 N8396JCurtsinger Joseph C Jr · Nolensville, TNBuilt 1981 · S/N 32R-8129075 N839SAUS Department Of Homeland Security · Washington, DCBuilt 2003 · S/N T20608391 N83BFHayssen Arthur H · Sebastopol, CABuilt 1976 · S/N 27-7654171 N83ECCarter Associates Inc · Sturgis, MIBuilt 2000 · S/N 4636307 N83JFForker John S · Orcas, WABuilt 1995 · S/N LIV 192 N83PAHill Enterprise Inc · Wilmington, DEBuilt 1981 · S/N 31-8112050 N83RAPessoa Guiherme · Winter Garden, FLS/N 31-638 N83WCRegistered aircraftBuilt 1966 · S/N 27-3281 N84008Harkey Wesley · Sherrills Ford, NCBuilt 1981 · S/N 28R-8131145 N8401DDarwin D Pluid · Eureka, MTBuilt 1981 · S/N 32R-8129076 N8403DTelford Aircraft LLC · Telford, TNS/N 32R-8129078 N8403PNewell Douglas Bryon · Sedalia, MOBuilt 1964 · S/N 24-3659 N8404PRegistration Pending · Pittsburgh, PARegistration pending, pending cancellationBuilt 1964 · S/N 24-3660 N8405PCarlin Chad P · San Juan Capistron, CAS/N 24-3661 N8408PBeavers Jeffrey · Metairie, LABuilt 1964 · S/N 24-3664 N8409HAerocolibri LLC · Nampa, IDBuilt 1981 · S/N 32R-8129084 N8409YRivera William Carl · Silver Spring, MDBuilt 1981 · S/N 32R-8129086 N8417P250 Dash 4 Associates Ltd · Yellow Springs, OHBuilt 1964 · S/N 24-3669 N841ADCedar Real Estate Inc · Anaheim, CABuilt 1973 · S/N 32-7340079 N841ATLuxury Transportation LLC · Talladega, ALBuilt 2004 · S/N 3257352 N841PSLivin The Dream Aviation LLC · Jupiter, FLBuilt 1967 · S/N 24-4684 N841WBQualitair LLC Trustee · MichelstadtBuilt 1978 · S/N 32R-7887075 N84219Manhattan Management Corp · Brooklyn, NYS/N 88 N8422PAnderson William · Creve Coeur, ILBuilt 1964 · S/N 24-3672 N8424ATringale Alison · Port Saint Joe, FLBuilt 1981 · S/N 32R-8129092 N84263Chadwick James B · Rch Palos Vrd, CABuilt 1981 · S/N 32R-8129094 N8426CHarper-Smith Michael · Tarzana, CABuilt 1976 · S/N 32R-7680114 N8427CMorgan Aviation LLC · Greensboro, NCBuilt 1981 · S/N 32-8124030 N8428PBertling Kevin M · Spring, TXBuilt 1964 · S/N 24-3675 N842TCWitte Transport LLC · West Plains, MOBuilt 2000 · S/N 18280841 N8430BTrident Aviation LLC · Bedford, NHBuilt 1981 · S/N 32R-8129097 N84337Kent East Inc · Wilmington, DES/N 32R-8129104 N8433AWoods Todd Ryan · Perry, OKBuilt 1981 · S/N 32-8124032 N8433YLomeli Rigoberto Orozco Jr · Longs, SCBuilt 1981 · S/N 32R-8129101 N84368N84368 LLC · Colorado Springs, COBuilt 1981 · S/N 32R-8129105 N84481Knopp Kathy · Virginia Beach, VABuilt 1981 · S/N 32R-8129113 N8448YDesert Green Turf Inc · Moses Lake, WABuilt 1981 · S/N 32R-8129111 N8448ZBliss Air LLC · Saint Joseph, MIBuilt 1981 · S/N 32R-8129112 N844PSDarr James E · Boron, CAFirst renewal noticeBuilt 1967 · S/N 24-4694 N844TPoukish John J Jr · Edwards, COBuilt 1989 · S/N 4622025 N8454EKompass Aviation LLC · Sheridan, WYBuilt 1999 · S/N 3257096 N8455DGrediagin Wayne S · Anchorage, AKBuilt 1981 · S/N 32R-8229003 N8455FHill City Aviation LLC · Concord, VABuilt 1981 · S/N 32R-8229004 N8455HDavidson James A · Frisco, TXBuilt 1981 · S/N 32R-8229005

Back to AD 84-19-03 R1