Skip to content

Registered aircraft · 17,027

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-03-03-R3') 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-03-03-R3') 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-03-03-R3')
    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-03-03-R3')
  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-03-03-R3')
  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-03-03-R3')
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.

N2949SRegistered aircraftBuilt 1967 · S/N 15066849 N2949YGallinat Theodore R · Milliken, COS/N 18253949 N29509Empty Nest Aviation LLC · Mckinney, TXBuilt 1968 · S/N 17700934 N2950FSpring Ronald L · London, OHBuilt 1966 · S/N 18257050 N2950JRunway Aviation Flight Training USA Corp · Rockwall, TXS/N 15065750 N2950SJohnson Aviation LLC · Middleton, IDS/N 15066850 N2950XEagle Sky Patrol Inc · Deadwood, SDBuilt 1967 · S/N 17700350 N2950YJohns Tyler J · Lake George, NYBuilt 1962 · S/N 18253950 N29512Heck Jean M · Colorado Springs, COBuilt 1968 · S/N 17700935 N29518Cardinal Aviation LLC · Chambersburg, PAS/N 17700939 N2951FHarvey Thomas R · Jacksonville, FLBuilt 1966 · S/N 18257051 N2951JJohnston Robert G · Rose Hill, KSBuilt 1966 · S/N 15065751 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 N2952FFisher Cody · Ennis, TXBuilt 1966 · S/N 18257052 N29530Rockdale Flying Tigers Inc · Rockdale, TXBuilt 1968 · S/N 17700944 N29531Pell George D · Hillsboro, ORBuilt 1968 · S/N 17700945 N2953829538 Aviation LLC · Fernandina Beach, FLBuilt 1968 · S/N 17700949 N29539Hoosier Fliers LLC · Bloomington, INBuilt 1968 · S/N 17700950 N2953SKelley Mark · El Granada, CABuilt 1967 · S/N 15066853 N2953XJohnston Daryl T · Euless, TXBuilt 1967 · S/N 17700353 N29548Novelli William L · Orangevale, CABuilt 1968 · S/N 17700956 N2954FWestberg Wayne A · Harvey, IABuilt 1966 · S/N 18257054 N2954XWilson Katelyn · Parkville, MOBuilt 1967 · S/N 17700354 N2954YFasano Garth · Boulder, COBuilt 1962 · S/N 18253954 N29554Eagle Sky Patrol · Deadwood, SDBuilt 1968 · S/N 17700960 N2955FBoyd John W · Milton, WABuilt 1966 · S/N 18257055 N2955JAguilar Honorio Alejandro · Anna, TXBuilt 1966 · S/N 15065755 N2955YAda Forestry Division · Malvern, ARBuilt 1962 · S/N 18253955 N29563Brown Winn D Jr · Horn Lake, MSBuilt 1968 · S/N 17700966 N2956JDecker Kathy A · Greenville, MIBuilt 1966 · S/N 15065756 N2956SPuder Karen D · Lenzburg, ILBuilt 1967 · S/N 15066856 N2956YRegistration Pending · Wilmington, DERegistration pendingBuilt 1962 · S/N 18253956 N2957JMcmahon Thomas G · Hoffman Estates, ILBuilt 1966 · S/N 15065757 N29581Bas Part Sales LLC · Greeley, COBuilt 1968 · S/N 17700972 N29584Eagle Sky Patrol Inc · Deadwood, SDBuilt 1968 · S/N 17700974 N29585Ramold Corey M · Gretna, NEBuilt 1968 · S/N 17700975 N2958XCooper Ronald C · Fowlerville, MIBuilt 1968 · S/N 17700358 N29592Reyner Matthew J · Georgetown, TXBuilt 1968 · S/N 17700978 N29593Else John J · Toledo, IABuilt 1968 · S/N 17700979 N29595Delta Fox Corp · Schaumburg, ILBuilt 1968 · S/N 17700980 N29596Murray Charles W · Reno, NVBuilt 1968 · S/N 17700981 N2959JJones Eugene B Jr · Pflugerville, TXBuilt 1966 · S/N 15065759 N2959SCobb Patricia J Trustee · North Las Vegas, NVS/N 15066859 N2959XCiochetti David · Kimberly, ORBuilt 1967 · S/N 17700359 N295GTMedina-Solla Edwin O · Carolina, PRBuilt 1966 · S/N 18257799 N295THHowser Anthony J · Batavia, OHS/N 15072736 N2960JGlinsky Edward Jr · Rhome, TXBuilt 1966 · S/N 15065760 N2960SDewitt Daniel · Camarillo, CABuilt 1967 · S/N 15066860

Back to AD 72-03-03 R3