Skip to content

Registered aircraft · 3,960

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-21-02-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:87-21-02-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:87-21-02-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:87-21-02-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:87-21-02-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:87-21-02-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.

N220HDAce Transport Service Inc · Wilmington, DEBuilt 1975 · S/N 310R0593 N220XPOleary Patrick G · Lake Tapps, WAS/N T310Q01020 N2211FSkyvault Holdings LLC · Saint Petersburg, FLBuilt 1960 · S/N 39235 N2211QHill Jeffrey A · Bridgeport, WVBuilt 1968 · S/N 421A0011 N2212ASiewart Michael · Columbus, OHS/N 310G-0018 N2214Q421 Partners · Delphi, INBuilt 1968 · S/N 421A0014 N221MBMendenhall Carl T · Sophia, NCBuilt 1966 · S/N 310L-0021 N2221QAviation Sales And Charter LLC · Dover, DEBuilt 1968 · S/N 421A0021 N222AWJust Planes Inc · Hobbs, NMFirst renewal noticeBuilt 1969 · S/N 310P-0106 N222AXGraven Timothy G · Foristell, MOBuilt 1970 · S/N 414-0078 N222BJFlight Smith LLC · Orem, UTBuilt 1972 · S/N 414-0264 N222DJGarone Michael A · Miami, FLBuilt 1967 · S/N 310L-0202 N222FGSkytravel LLC · Victoria, TXBuilt 1981 · S/N 414A0823 N222FWLindsey Daniel Rey · Clovis, NMS/N 310I0002 N222LTwo Motor Odor LLC · Paris, TXS/N 320E-0053 N222MDElx Aviation LLC · Hartford, MIBuilt 1974 · S/N 310Q1013 N222PEPacific Air Charters Inc · Honolulu, HIBuilt 1976 · S/N 310R0632 N222PLAnderas Per R · Green Bay, WIS/N 414A0521 N222PRFlying South LLC · Wilmington, DEBuilt 1973 · S/N 4140384 N222RDAviation Consultants Inc · San Luis Obispo, CABuilt 1977 · S/N 340A-0366 N222RMKelco LLC · Helena, MTBuilt 1971 · S/N 414-0168 N222STEau Claire Aviation LLC · Eau Claire, WIBuilt 1976 · S/N 310R0679 N222SVEllsworth Jason W · Hamilton, MTS/N 414-0164 N2232FPritchard Dale G · St Maries, IDBuilt 1966 · S/N 310L-0032 N2235QSparx Logistics USA Ltd · Charlotte, NCBuilt 1968 · S/N 421A0035 N2236QWoods Leland W · Klamath Falls, ORBuilt 1968 · S/N 421A0036 N223PBHyannis Air Service Inc · Hyannis, MABuilt 1979 · S/N 402C0105 N2240FFenco Holdings Inc · Cheyenne, WYS/N 310L0040 N2241FHaag Douglas A · Collierville, TNBuilt 1967 · S/N 310L-0041 N2244FSky King 44f LLC · Florence, SCBuilt 1966 · S/N 310L-0044 N2249MSky Visions Photography LLC · Manitowoc, WIFirst renewal noticeBuilt 1966 · S/N 310L-0049 N2252FAdh Enterprises Inc · Sherman, ILBuilt 1966 · S/N 310L-0052 N2256FWesellairplanes.Com Inc · Wilmington, DES/N 310L-0056 N2259FDemon21 LLC · Granville, OHBuilt 1966 · S/N 310L-0059 N225LRice James M · Austin, TXBuilt 1965 · S/N 310J-0025 N2265FRegistration Pending · Wilmington, DERegistration pendingBuilt 1967 · S/N 310L-0065 N2266FTechnical Education Services Inc · Virginia Beach, VAS/N 310L-0066 N2268CCozach LLC · Wilmington, DEBuilt 1982 · S/N T30300081 N2268FKephart Peter J · Washington, MOBuilt 1966 · S/N 310L-0068 N226HPRegistration Pending · Valdosta, GARegistration pendingBuilt 1978 · S/N 414A0084 N2270FAlbair William R · Hampden, MEBuilt 1967 · S/N 310L-0070 N2272FGear Down Hangar LLC · Phoenix, AZBuilt 1967 · S/N 310L-0072 N2274FElliott Areospace LLC · Kalispell, MTBuilt 1967 · S/N 310L-0074 N2275CCrusader Medical Consulting LLC · Boonville, INBuilt 1982 · S/N T30300085 N2281FClassic Air Aviation LLC · Mesa, AZBuilt 1967 · S/N 310L-0081 N2282FSjoblom Donald W · Maple Grove, MNBuilt 1967 · S/N 310L-0082 N228JHBuzzed Landing LLC · Ocean Springs, MSBuilt 1980 · S/N 421C-1006 N228RDShrader J B · Yuma, AZBuilt 1966 · S/N 310K0181 N2293FTwo Mile High Mining LLC · Victor, COBuilt 1970 · S/N 414-0097 N2296FAttitude Aviators Inc · North Myrtle Beach, SCBuilt 1967 · S/N 310L-0096

Back to AD 87-21-02 R1