Skip to content

Registered aircraft · 40,473

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:80-04-03-R2') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:80-04-03-R2') 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:80-04-03-R2')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:80-04-03-R2')
  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:80-04-03-R2')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:80-04-03-R2')
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.

N4452JFly Around Alaska LLC · Palmer, AKBuilt 1967 · S/N 28-22859 N4452PAviation Business Corporation · Saint Louis, MOBuilt 1961 · S/N 23-1969 N4452RZitting Fredrick J · Colorado City, AZS/N 17263194 N4452ZMutch Max Samuel · Anchorage, AKS/N 18-8799 N44530Wycoff Ryan · Watauga, TXS/N 28-7425422 N44534Sale Reported · Keystone Heights, FLSale reported, pending cancellationBuilt 1974 · S/N 28-7425423 N44536Dickamore Chris E · Lewiston, IDS/N 186611 N44537Majoka Hasham A · Southwick, MABuilt 1974 · S/N 28-7415659 N44538Berkshire Aviation Enterprises LLC · Great Barrington, MAS/N 28-7415660 N4453ANau Evan D · Manchester, MIS/N 22-3786 N4453RJackson Robin D · Harlan, IABuilt 1974 · S/N 17263195 N4453ZBoyer Skip P · Oak Harbor, WABuilt 1969 · S/N 18-8800 N44542Waldraff Hans C · Delafield, WIS/N 28-7415662 N44543Evers Jeffrey P · Export, PABuilt 1974 · S/N 28-7415663 N44546Polka Todd M · New Philadelphia, OHBuilt 1974 · S/N 28-7405258 N4454AMcclanahan Luke D · Decherd, TNFirst renewal noticeBuilt 1956 · S/N 22-3787 N4454JEvans Craig · Bastrop, LABuilt 1967 · S/N 28-22861 N4454RDekle Drew · Athens, GAS/N 17263196 N4454ZWilliams Kenneth J · Wasilla, AKS/N 18-8801 N44553Murrell Stanley D · Alabaster, ALBuilt 1974 · S/N 28-7425425 N44555Miloud Chadd K · Fort Worth, TXS/N 28-7415667 N44556Sayonara Air LLC · Old Hickory, TNBuilt 1974 · S/N 28-7405260 N4455TK-T Customs LLC · Mustang, OKBuilt 1972 · S/N 28-7205163 N4455XHarding Candace B · Livermore, CABuilt 1975 · S/N 28-7615013 N4455ZWindsor Greg A · Anchorage, AKBuilt 1965 · S/N 18-8334 N44566Skybound Aviation LLC · Kernersville, NCBuilt 1974 · S/N 28-7415668 N4456RTruskey David R · Dauphin, PABuilt 1974 · S/N 17263198 N4456ZHayton James B · Sedro Woolley, WAS/N 18-8803 N44571Boas Mark S · Hollywood, MDBuilt 1974 · S/N 28-7415670 N44575Fit Overflow LLC · Davidson, NCBuilt 1974 · S/N 28-7425427 N44579Schaible Peter J · Springfield, VABuilt 1974 · S/N 28-7415672 N4457PSkyhaven Airport Inc · Tunkhannock, PABuilt 1961 · S/N 23-1974 N4457ZK Ranches Aviation · Bozeman, MTBuilt 1969 · S/N 18-8804 N44580Mtt Aviation Services Inc · Johnstown, PABuilt 1974 · S/N 28-7415673 N44583Griffin Avionics Inc · Hyannis, MABuilt 1974 · S/N 28-7415674 N44584Boomerang Air LLC · Cedar Park, TXBuilt 1974 · S/N 28-7405262 N4458JMillan Sanchez Omar · Sussex, NJBuilt 1967 · S/N 28-22866 N4458ZAerial Crop Care Co · Hebron, NDBuilt 1969 · S/N 18-8805 N44590Lee John Michael · Van Nuys, CABuilt 1974 · S/N 28-7425429 N44592Registration Pending · Venice, FLRegistration pendingS/N 28-7415676 N44593Mcgaughey Kevin B · Milan, TNBuilt 1974 · S/N 28-7415678 N44597Tob Cherokee Flyers · Kasson, MNBuilt 1974 · S/N 28-7525001 N4459JCoastal Virginia Aviation LLC · Chesapeake, VAS/N 28-22868 N445DHOhio University · Albany, OHBuilt 2005 · S/N 2842233 N445KCCramer Kirby · Fallbrook, CABuilt 2004 · S/N 70121 N445PASkywest Leasing Inc · St George, UTBuilt 2001 · S/N 2843500 N445RDensmore John L · Conway, WABuilt 1974 · S/N 17262596 N445WTClayton Edwin G · North Chesterfield, VABuilt 1964 · S/N 2776 N44604Lydic Daniel · Pittsburgh, PABuilt 1974 · S/N 28-7425431 N44605Luitjens Jacob J · Lagrange, GABuilt 1974 · S/N 28-7415681

Back to AD 80-04-03 R2