Skip to content

Registered aircraft · 1,421

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

N1007XD&R LLC · Emory, TXS/N 34-7570182 N1019TAndrew University · Berrien Springs, MIBuilt 2006 · S/N 4496232 N101FMN101fm Inc Trustee · Wilmington, DES/N 3433153 N101MLWesolowski Trevor · Berkeley, CABuilt 1981 · S/N 34-8233066 N102DHPiper Aircraft Inc · Vero Beach, FLBuilt 2025 · S/N 4496597 N102LLExecutive Aviation LLC · Peoria, AZS/N 34-7970483 N103BMSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1980 · S/N 44-8107007 N1044HWiebe Farms Inc · Hooker, OKS/N 34-7770100 N104JHDouble Helix Solutions LLC · Kamuela, HIS/N 34-7670163 N104WPMartyn Christian A · Hallendale, FLBuilt 1977 · S/N 34-7870048 N104WTFour Whiskey Tango LLC · Grosse Pointe Park, MIBuilt 2004 · S/N 3449301 N1054XMurphy George E · Robinson, ILBuilt 1975 · S/N 34-7570195 N10691Reed Kerr Aviation Inc · Wilmington, DEBuilt 1984 · S/N 34-8433050 N1070XMosby Group LLC · Edgerton, MOBuilt 1975 · S/N 34-7570199 N107ABHobart Aviation Inc · Akron, OHBuilt 1977 · S/N 34-7770341 N109WESpace Coast Aircraft Co · Merritt Island, FLBuilt 1978 · S/N 347870405 N10BNBlack Thomas D DBA · Clearwater, FLBuilt 1975 · S/N 34-7570050 N10DRFlying W LLC · Camden, DEBuilt 1994 · S/N 3448044 N10NZConnor Reginald W · The ValleyNon-citizen corporation, flight hours not reportedS/N 34-7870158 N10PBNeves Frank Jr · North Miami Beach, FLBuilt 1974 · S/N 34-7570031 N1106XVan Vleet Merlin D · Kingman, AZBuilt 1975 · S/N 34-7570212 N110CAFargo Jet Center LLC · Fargo, NDBuilt 1975 · S/N 34-7570219 N110GGSkyview Aviation LLC · Tracy, CABuilt 2024 · S/N 3449486 N110MJTuggle Jason C · Liberty Hill, TXBuilt 1975 · S/N 34-7570117 N110RVMillspaugh John · Weatherford, OKBuilt 1981 · S/N 34-8133196 N111PHGood Flight Aviation LLC · Stockton, CABuilt 1978 · S/N 34-7970001 N111RXThompson William · Tampa, FLS/N 347770134 N111SMMuller Aviation LLC · New Baltimore, MIBuilt 1977 · S/N 34-7770333 N113DFRegistered aircraftBuilt 1998 · S/N 3449062 N1142XAerofeather Aviation Inc · Suffolk, VAS/N 34-7570221 N114JRN114jr LLC · Canyon Lake, CABuilt 1975 · S/N 34-7570152 N114NXin Han Aviation LLC · Atwater, CABuilt 1979 · S/N 44-7995289 N1162XSeeding Operations And Atmospheric Reseach LLC · San Angelo, TXBuilt 1975 · S/N 34-7570225 N1166XEagle Aviation Inc · Tucson, AZBuilt 1975 · S/N 34-7570227 N1176XLyvers Joseph D · Louisville, KYBuilt 1975 · S/N 34-7570231 N118ATAirline Transport Professionals Corp Of USA · Wilmington, DEBuilt 2000 · S/N 4496034 N1194XCantrell William Terry · Spring Hill, TNS/N 34-7570236 N11HRHf Aero LLC · Lusby, MDBuilt 1979 · S/N 34-7970233 N11YNN3412w LLC · Lithia, FLS/N 34-8070059 N120RHAir Puerto Rico Corp · Aguadilla, PRBuilt 1978 · S/N 44-7995118 N121WAWeather Modification LLC · Fargo, NDBuilt 1979 · S/N 34-7970435 N1221KAirline Transport Professionals Corp Of USA · Wilmington, DES/N 44-7995295 N1234UInternational Air Services Inc Trustee · Carson City, NVS/N 348070336 N123APJc Air Academy Inc · Stockton, CABuilt 1977 · S/N 34-7770015 N123FLPiper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 4496648 N123TJClover Management Systems Inc · Sanford, FLBuilt 1978 · S/N 44-7995045 N125MGHillsboro Aero Academy LLC · Hillsboro, ORBuilt 2002 · S/N 4496152 N125MLL3 Cts Airline Academy · Sanford, FLBuilt 2019 · S/N 4496480 N1265HKingsky Flight Academy LLC · Lakeland, FLS/N 34-7770117 N126MLL3 Cts Airline Academy · Sanford, FLBuilt 2019 · S/N 4496481

Back to AD 2003-11-14