Skip to content

Registered aircraft · 563

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:75-25-03') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:75-25-03') 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:75-25-03')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:75-25-03')
  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:75-25-03')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:75-25-03')
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 N102LLExecutive Aviation LLC · Peoria, AZS/N 34-7970483 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 N1054XMurphy George E · Robinson, ILBuilt 1975 · S/N 34-7570195 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 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 N110MJTuggle Jason C · Liberty Hill, TXBuilt 1975 · S/N 34-7570117 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 N1142XAerofeather Aviation Inc · Suffolk, VAS/N 34-7570221 N114JRN114jr LLC · Canyon Lake, CABuilt 1975 · S/N 34-7570152 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 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 N121WAWeather Modification LLC · Fargo, NDBuilt 1979 · S/N 34-7970435 N1234UInternational Air Services Inc Trustee · Carson City, NVS/N 348070336 N123APJc Air Academy Inc · Stockton, CABuilt 1977 · S/N 34-7770015 N1265HKingsky Flight Academy LLC · Lakeland, FLS/N 34-7770117 N1278HMetzner Brad · Visalia, CAS/N 34-7770118 N129AVCochran Jeffrey · Lincoln, NEBuilt 1980 · S/N 34-8070309 N1316ASky West Aviation Inc Trustee · Albuquerque, NMS/N 347770258 N132CTHanger Six LLC · Birmingham, ALBuilt 1978 · S/N 34-7870179 N1334HPreskar Michael H · Ione, CABuilt 1977 · S/N 34-7770121 N1397HIngold Terry L · Albemarle, NCS/N 34-7770124 N13AGWeather Modification LLC · Fargo, NDBuilt 1977 · S/N 34-7770115 N13LMTupelo Limited Lc · Lake Charles, LAS/N 34-7870075 N1411XMaarouf Dan H · Seabrook, TXBuilt 1975 · S/N 34-7570239 N1416XTop Tier Truck And Trailer LLC · Dimmitt, TXBuilt 1975 · S/N 34-7570241 N142GDDeaero LLC · Darwin, MNBuilt 1980 · S/N 34-8070314 N1451XTrb Aviation Inc · Washington, DCBuilt 1975 · S/N 34-7570248 N1467XWilson David K · Mckinney, TXBuilt 1975 · S/N 34-7570252 N147BZSpace Coast Aircraft Co · Merritt Island, FLBuilt 1978 · S/N 34-7870359 N148PFMacallen Chemical Inc · Monroe, LABuilt 1978 · S/N 34-7970017 N14FZWurzer Frank · Tallmadge, OHBuilt 1978 · S/N 34-7870122 N14JNNational Test Pilot School · Mojave, CABuilt 1975 · S/N 34-7570254 N1532XRaymond Darwin V · Glenwood Springs, COBuilt 1975 · S/N 34-7570275 N1536XClark Christopher · Ormond Beach, FLBuilt 1975 · S/N 34-7570276 N1551XLeverson Christopher · Austin, TXBuilt 1975 · S/N 34-7570283

Back to AD 75-25-03