Skip to content

Registered aircraft · 54,019

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:87-20-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:87-20-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:87-20-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:87-20-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:87-20-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:87-20-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.

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 N2952AWeyl George R · Bigfork, MTBuilt 1953 · S/N 30152 N2952CToil Oregon Vineyards LLC · Walla Walla, WABuilt 1954 · S/N 30852 N2952EDayton Michael R · Glen Allen, VABuilt 1978 · S/N 17271382 N2952FFisher Cody · Ennis, TXBuilt 1966 · S/N 18257052 N2952UOrr Enterprises Inc · Hay Springs, NEBuilt 1963 · S/N 17250552 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 N2953EJensen James A · Madison, WIBuilt 1978 · S/N 17271383 N2953SKelley Mark · El Granada, CABuilt 1967 · S/N 15066853 N2953XJohnston Daryl T · Euless, TXBuilt 1967 · S/N 17700353 N29542Giannakakis Peter J · Monroe, MIBuilt 1973 · S/N 21059866 N29548Novelli William L · Orangevale, CABuilt 1968 · S/N 17700956 N2954DRosales Mariano L III · Naperville, ILBuilt 1955 · S/N 26897 N2954FWestberg Wayne A · Harvey, IABuilt 1966 · S/N 18257054 N2954UTiger Flight LLC · Lake Butler, FLBuilt 1963 · S/N 17250554 N2954XWilson Katelyn · Parkville, MOBuilt 1967 · S/N 17700354 N2954YFasano Garth · Boulder, COBuilt 1962 · S/N 18253954 N29552Montgomery Skyhawk LLC · Bethesda, MDBuilt 1974 · S/N 17264118 N29554Eagle Sky Patrol · Deadwood, SDBuilt 1968 · S/N 17700960 N2955DWalsh David E · North Platte, NEBuilt 1955 · S/N 26898 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 N2956UMitchell Casey D · Lucedale, MSBuilt 1963 · S/N 17250556 N2956YRegistration Pending · Wilmington, DERegistration pendingBuilt 1962 · S/N 18253956 N2957CCurrier Dustan · Fairbanks, AKS/N 30857 N2957JMcmahon Thomas G · Hoffman Estates, ILBuilt 1966 · S/N 15065757 N2957KSutton Aircraft Salvage LLC · Palmer, AKBuilt 1980 · S/N 18053138 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 N2958CSale Reported · Anchorage, AKSale reportedBuilt 1954 · S/N 30858 N2958KPionair Inc · ChamBuilt 1980 · S/N 18053139 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

Back to AD 87-20-03 R2