Skip to content

Registered aircraft · 25,370

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-25-07-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:80-25-07-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:80-25-07-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:80-25-07-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:80-25-07-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:80-25-07-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.

N214JC214 Mooney LLC · Boca Raton, FLBuilt 1978 · S/N 24-0706 N214LHRocky Mountain Flight Consultants LLC · Boulder, COBuilt 2005 · S/N 494-2005 N214SHSiu Ena · Reno, NVBuilt 1963 · S/N E189 N214TJVector Aeromedical Services LLC · Smithfield, NCBuilt 1979 · S/N R18201275 N2150ELeuer Nicholas J · Emmetsburg, IABuilt 1978 · S/N 17271170 N21515Airline Transport Professionals Corp Of USA · Wilmington, DEBuilt 1974 · S/N 17263960 N21517Leighton Bryce L · Griswold, IABuilt 1974 · S/N 17263961 N2152QGeorge R Jones Jr · Dallas, TXBuilt 1974 · S/N 177RG0552 N21535Wilson Chad M · Mount Ida, ARBuilt 1974 · S/N 17263965 N2153CReed Matthew E · Palmerton, PABuilt 1978 · S/N 17702742 N21543Lima Bravo Group Corp · Miami, FLBuilt 1974 · S/N 17263967 N21553Peacock Sidney T · Davison, MIBuilt 1974 · S/N 17263970 N2155PRegistered aircraftBuilt 1998 · S/N 24-3430 N2155QFellows Walter · Prineville, ORBuilt 1974 · S/N 177RG0555 N21564Miller John H · Newnan, GAFirst renewal noticeBuilt 1974 · S/N 17263972 N2156QBowers Jackie M · Elmer, NJBuilt 1974 · S/N 177RG0556 N21571Schwartz Robert J · Coshocton, OHBuilt 1974 · S/N 17263974 N21576Barnes Robert R · Wilton Manors, FLBuilt 1974 · S/N 17263975 N21580Bas Part Sales LLC · Greeley, COBuilt 1974 · S/N 17263977 N21585Ck Leasing Services LLC · Wilmington, DES/N 17263978 N21588Jackson Hole Airport Board · Jackson, WYBuilt 1974 · S/N 17263979 N2158JMccormick Eugene C DBA · Tyler, ALBuilt 1979 · S/N T18803395T N215AFArmed Forces Aero Club · San Diego, CABuilt 1978 · S/N 17270844 N215BCMetzler Alan J · Reedsville, PABuilt 2005 · S/N 468-2005 N215DBHurst Jeffrey A Trustee · Tahoe City, CABuilt 1980 · S/N R18201641 N215FRJjg Aviation LLC · Miami, FLBuilt 1978 · S/N 17271822 N215GNBbt Jewelry LLC · Miami, FLS/N P21000335 N215RVJet & Rotor Aviation LLC · Sacramento, CABuilt 1973 · S/N 67-73 N2160JSnider Scott DBA · Turner, MTBuilt 1979 · S/N T18803397T N21616Joseph Tamar Bar · Chanute, KSBuilt 1972 · S/N 18800910 N21618Schwend Brian · Forsyth, MTBuilt 1972 · S/N 18800912 N2161EBryn Terry P · Dazey, NDBuilt 1978 · S/N 17271172 N2161QSalty Dawg Aircraft Inc · Gasport, NYBuilt 1974 · S/N 177RG0561 N21641Bunger William D · Upland, NEBuilt 1972 · S/N 18800927 N21643A&E Flying Club Of Los Angeles · Hawthorne, CABuilt 1974 · S/N 17263982 N21648Fox Victor Aviation LLC · Newnan, GAS/N 17263983 N21651Syverson Ronn · Mcintosh, MNBuilt 1972 · S/N 18800934 N2165EMaravel Richard N · Trinity, FLBuilt 1978 · S/N 17271174 N2166QLiberty Partners Inc · Okmulgee, OKBuilt 1974 · S/N 177RG0566 N2167CStarkys Equipment Leasing LLC · Manchester, MIBuilt 1978 · S/N 17702743 N2167ESittler Charles A · Tulsa, OKS/N 17271176 N21686Sapp Creek Aviation LLC · Omega, GABuilt 1972 · S/N 18800958 N21690Flight Center International LLC · Hollywood, FLBuilt 1974 · S/N 17263987 N21699Ramirez Sam Ernest · Yelm, WABuilt 1974 · S/N 17263988 N2169CAddison Jeffery A · Lafayette, LABuilt 1978 · S/N 17702744 N2169QWhite Beth A · Keene, NHBuilt 1974 · S/N 177RG0569 N216ACLetourneau University · Longview, TXBuilt 2000 · S/N 1381-2000 N216AFArmed Forces Aero Club Inc · San Diego, CABuilt 1980 · S/N 17274165 N216BCBell Wendell D · Littlerock, WABuilt 2007 · S/N 493-2007 N216CLMisamore Steven Edward · Mount Juliet, TNS/N 15284706

Back to AD 80-25-07 R1