Skip to content

Registered aircraft · 1,578

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:72-14-08-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:72-14-08-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:72-14-08-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:72-14-08-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:72-14-08-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:72-14-08-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.

N3056LFowler Larry K · Harrison, ARBuilt 1965 · S/N 310J0056 N3061DJeppson Edward Mckay Trustee · South Jordan, UTBuilt 1956 · S/N 35261 N3063DCase William M · Klamath Falls, ORBuilt 1956 · S/N 35263 N3064DLebron R Luke · Gulfport, MSS/N 35264 N3068LMirage Air Ltd · Wilmington, DENon-citizen corporation, flight hours not reportedS/N 310J0068 N3069DSmith Gregory E · White Lake, MIBuilt 1956 · S/N 35269 N3070LClark Kenneth N · Tempe, AZBuilt 1965 · S/N 310J0070 N3071LDishburger Samuel T · Westfield, INBuilt 1965 · S/N 310J0071 N3073LSheakley John W DBA · Meadville, PABuilt 1965 · S/N 310J0073 N3075LAlvis Michael E · Parkton, NCS/N 310J0075 N3079LTff Inc · Parma, MIBuilt 1965 · S/N 310J0079 N3083LPrice Randy L · Pahrump, NVS/N 310J0083 N3088LRice James M · Austin, TXS/N 310J0088 N3091DBella Farms Inc · Hayes Center, NEBuilt 1956 · S/N 35291 N3091LAbbasi Babak · Murrieta, CABuilt 1965 · S/N 310J0091 N3094DAberdeen Pilots LLC · Boerne, TXBuilt 1956 · S/N 35294 N3095DIrvine William G · Rosamond, CABuilt 1956 · S/N 35295 N30HCKinetic Concepts LLC · Pensacola, FLS/N 310Q1079 N30TAero Quest LLC · Olive Branch, MSBuilt 1962 · S/N 310G-0031 N310AFSelwa Michael A · Oconomowoc, WIBuilt 1974 · S/N 310Q1121 N310ATBelknap Scott M · Temecula, CABuilt 1965 · S/N 310J0097 N310AWBetty Eric · Old Hickory, TNBuilt 1969 · S/N 310P0231 N310BDSale Reported · Fort Wayne, INSale reportedBuilt 1965 · S/N 310J0013 N310BJJ A Flight Services LLC · Sugar Grove, ILBuilt 1973 · S/N 310Q0759 N310BMTeam 67 LLC · Mount Pleasant, IABuilt 1973 · S/N 310Q0987 N310BSKwe Inc · Melbourne Beach, FLBuilt 1973 · S/N 310Q0822 N310CCLance Johnson Ministries Inc · Calhoun, GABuilt 1973 · S/N 310Q0970 N310CMAir Positive LLC · Selbyville, DEBuilt 1969 · S/N 310P-0178 N310CWWahl Charles · Cameron Park, CABuilt 1967 · S/N 310N-0015 N310DLPuzio Scott M · Locust Grove, GABuilt 1966 · S/N 310K0191 N310EBWeatherproof Montana LLC · Missoula, MTBuilt 1956 · S/N 35446 N310EKCassel Paul · Hernando, MSBuilt 1973 · S/N 310Q1009 N310ERAlbrecht Wallace L · Fayetteville, TXBuilt 1966 · S/N 310K0187 N310ESDiamond P Aviation LLC · Riverton, ILBuilt 1973 · S/N 310Q0714 N310FCScott Jed L · Salem, VABuilt 1974 · S/N 310Q1140 N310FFHangar 28 Aviation Holdings I LLC · Cody, WYBuilt 1960 · S/N 39053 N310FGMcalpine David B · Fort Worth, TXBuilt 1959 · S/N 35876 N310FPMorley Thomas O · Riverside, CAS/N 310K0027 N310GQMayo Ray C Jr · Shreveport, LABuilt 1965 · S/N 310J0131 N310GRDailey Jordan · Umatilla, FLBuilt 1968 · S/N 310P0064 N310JRegistration Pending · El Paso, TXRegistration pending, canceledBuilt 1965 · S/N 310J0021 N310JBBickel Aviation LLC · Wilmington, DES/N 310H0031 N310JDPritchett Jerry D · Lakeville, MNBuilt 1965 · S/N 310J0177 N310JTCowan David E · Mount Pleasant, SCBuilt 1956 · S/N 35486 N310KTSmith Gregory E · White Lake, MIBuilt 1958 · S/N 38122 N310LBTradewind Aviation Management LLC · Oxford, GABuilt 1973 · S/N 310Q0980 N310LEJones Kent D · St George, UTS/N 35425 N310LGCccp LLC · Mustang, OKS/N 310K0206 N310LMMurphy David · Fort Valley, GABuilt 1960 · S/N 39086 N310LRCasavia Corp · Guelph OntarioBuilt 1957 · S/N 38017

Back to AD 72-14-08 R1