Skip to content

Registered aircraft · 40,472

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.

N29469Gem Property Investments LLC · San Antonio, TXBuilt 1968 · S/N 17700910 N2946EHigh Wing Air Services LLC · Merritt Island, FLBuilt 1978 · S/N 17271380 N2946LRegistration Pending · Denver, NCRegistration pending, pending cancellationBuilt 1967 · S/N 670080 N2946MAir-Ag Inc · Tarboro, NCBuilt 1977 · S/N 28-7816325 N2946PClassic Aircraft LLC · South Bend, INBuilt 1955 · S/N 22-3216 N2946TNorlund Christopher Scott · Safford, AZS/N 070 N29474Leslie Jason · Dayton, OHBuilt 1968 · S/N 17700913 N29479Kozminski Michael J · Caledonia, WIBuilt 1968 · S/N 17700914 N2947GHackwell Calvin · Enoch, UTBuilt 1960 · S/N 302 N2947LPeoples John Robert Jr · Hixson, TNBuilt 1967 · S/N 670081 N2947PWhite Hat Repair LLC · Greenleaf, IDBuilt 1955 · S/N 22-3219 N2947VEd Henderson LLC · Bowling Green, MOS/N 1085 N29480Cobra Aviation LLC · Kalispell, MTBuilt 1968 · S/N 17700915 N29481Walle Heidi N · Coarsegold, CABuilt 1968 · S/N 17700916 N29485Lily Anne Aviation LLC · Bad Axe, MIBuilt 1968 · S/N 17700919 N29486Lee Kevin M · Rexburg, IDBuilt 1988 · S/N 1055 N29488Luther Charles A · Walnut Creek, CABuilt 1968 · S/N 17700921 N2948PMurdock Seth A · Dayton, WAS/N 22-3220 N2948QMartin John Michael · Kingwood, TXBuilt 1977 · S/N 28-7790427 N2948TCoyle Jack R · Neosho, MOBuilt 1967 · S/N 072 N2949LShaker M R · Green Bay, WIS/N 670083 N294BWeiss Adam A · Shell Knob, MOBuilt 2004 · S/N 90606 N294PACoco Aircraft Inc · Merritt Island, FLBuilt 2002 · S/N 2843504 N294TWLouris Thomas W · Lake Oswego, ORBuilt 1965 · S/N 28-2202 N29509Empty Nest Aviation LLC · Mckinney, TXBuilt 1968 · S/N 17700934 N2950AInnoutaero LLC · Stockton, CAS/N 44-7995315 N2950GLcc East LLC · Freehold, NJBuilt 1979 · S/N 28-7916572 N2950QGriffin Russell A · Jackman, MEBuilt 1988 · S/N 1046 N2950TRandall Aviation LLC · Arvada, COBuilt 1967 · S/N 075 N2950WTaglilatelo Dale R · Cocoa, FLBuilt 1979 · S/N 28--7916577 N2950XEagle Sky Patrol Inc · Deadwood, SDBuilt 1967 · S/N 17700350 N2950ZLand Olin Franklin Jr · Baton Rouge, LABuilt 1959 · S/N 22-6923 N29510N29510 LLC · Farmington, UTBuilt 1988 · S/N 1047 N29512Heck Jean M · Colorado Springs, COBuilt 1968 · S/N 17700935 N29518Cardinal Aviation LLC · Chambersburg, PAS/N 17700939 N2951GFletcher Flying Service 419 LLC · Labelle, FLBuilt 1967 · S/N 62 N2951MStallone Anthony D · Anchorage, AKBuilt 1945 · S/N 12-1346 N2951ZToscano Bruce A · Colfax, WABuilt 1959 · S/N 22-6924 N29520Best Equipment Leasing LLC · Bakersfield, CABuilt 1968 · S/N 17700940 N29521Harmon Brian L · Wichita, KSS/N 17700941 N29523Mcgaha Edgar E Jr · Rio Vista, CABuilt 1968 · S/N 17700942 N2952EDayton Michael R · Glen Allen, VABuilt 1978 · S/N 17271382 N2952PTrue Carl B · Avalon, CABuilt 1955 · S/N 22-3224 N2952TWalters James F · Richton, MSBuilt 1967 · S/N 077 N2952YPreston Marty D · South Bend, INBuilt 1979 · S/N 28-7990580 N29530Rockdale Flying Tigers Inc · Rockdale, TXBuilt 1968 · S/N 17700944 N29531Pell George D · Hillsboro, ORBuilt 1968 · S/N 17700945 N29535Clouse Tyler Woods · Forest City, IABuilt 1979 · S/N 28-7990448 N29537Garcia John C · Peoria, AZBuilt 1979 · S/N 28-7990449 N2953829538 Aviation LLC · Fernandina Beach, FLBuilt 1968 · S/N 17700949

Back to AD 80-04-03 R2