Skip to content

Registered aircraft · 5,102

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:81-12-06-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:81-12-06-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:81-12-06-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:81-12-06-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:81-12-06-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:81-12-06-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.

N517FDJoyner James M · Eagle River, AKBuilt 2001 · S/N 3257263 N51824US Department Of Homeland Security · Washington, DCBuilt 2003 · S/N T20608390 N51847Rippe Ryan · Fairbury, NEBuilt 2002 · S/N T20608363 N51849O'Ryan Air LLC · Wichita, KSBuilt 2002 · S/N T20608364 N5188BRegier Tom · Dinuba, CABuilt 2002 · S/N T18208141 N5190AArias Antonio · Lakeway, TXS/N T18208143 N5193MTar Pit Investments LLC · Austin, TXBuilt 2002 · S/N T18208146 N5198GConaway David L · Las Vegas, NVBuilt 2002 · S/N T18208150 N519CASakitumi LLC · Wilmington, DES/N 14239 N519MBThomas Andrea · Sacramento, CAS/N 27-0200 N519WATropeano Construction Inc · Belleview, FLBuilt 1970 · S/N 3081 N519WRTsmhta LLC · Indianapolis, INBuilt 2000 · S/N 4636259 N51GCCragg Gordon E · Georgetown, TXBuilt 1966 · S/N 27-3516 N51HPJ R'S Downwind Aviation Inc · Lantana, FLBuilt 1974 · S/N 27-7405412 N51KMBaker Leasing LLC · Kotzebue, AKBuilt 1973 · S/N 31-7305009 N51PGFly N' Fish LLC · Jacksonville, FLBuilt 1984 · S/N 32R-8529003 N5201SVancuren Maryann · Owasso, OKBuilt 1970 · S/N 32-40885 N5202SWilliams Christopher Lee · Wallingford, KYBuilt 1970 · S/N 32-40886 N5205SAgrivation LLC · Indianola, IABuilt 1969 · S/N 32-40894 N5205UVoloshin Vitaly Alexandrovich · Seattle, WABuilt 2002 · S/N T18208153 N5207SOhio Air Enterprises LLC · Lancaster, OHBuilt 1969 · S/N 32-40898 N5208S5fs Aviation LLC · Lewes, DEBuilt 2002 · S/N 18281138 N5209FMidwest Avtech Inc · South Barrington, ILBuilt 2002 · S/N T18208155 N5209POliver Dennis L · Williamsburg, IABuilt 2002 · S/N T18208156 N5211VPipe Dream LLC · Stout, OHBuilt 2002 · S/N T20608379 N5212SHastings Reginald J · Brookshire, TXBuilt 1970 · S/N 32S-40904 N5215SFive Generation Flyers LLC · Melbourne, FLBuilt 1970 · S/N 32-40909 N5219EUS Department Of Homeland Security · Washington, DCBuilt 2003 · S/N T20608383 N521ASStanz John Trustee · Maple City, MIBuilt 1982 · S/N 32R-8229051 N521AWUrban Equipment LLC · Vineland, NJBuilt 1971 · S/N 31-765 N521EEMhg Leasing LLC · Edgewood, KYBuilt 1979 · S/N 27-7954067 N5220AMarshall Chadwick J · Fort Walton Beach, FLBuilt 2002 · S/N 18281149 N5221S3a LLC · Trussville, ALS/N 32-40915 N5222GHanger C16 LLC · Pinckney, MIBuilt 2002 · S/N T18208164 N5223SFrancis Larry Wayne · Whitewright, TXBuilt 2003 · S/N T20608384 N5225YGarret G Enterprises LLC DBA · Lakewood, COBuilt 2002 · S/N T18208165 N5229SInk International Inc · Lawrenceville, GABuilt 1970 · S/N 32-40933 N522CAC-140 Company LLC · Milton, FLBuilt 1971 · S/N 27-4711 N5235BBrit Ltd · Wilmington, DEBuilt 2001 · S/N 3257222 N52394Aero Missions LLC · Zeeland, MIBuilt 1973 · S/N 31-7401207 N523MLForster David · Friendswood, TXBuilt 1989 · S/N 4622087 N5242STanakon Inc · Fairbanks, AKBuilt 1970 · S/N 32-40930 N5246SPapa Kilo Aviation LLC · Palm Beach, FLBuilt 1970 · S/N 32-40950 N5247FBasha Joseph W Jr · Alexandria, LAS/N 32-7740002 N524ERGrant Aviation Inc · Anchorage, AKBuilt 1981 · S/N 31-8152132 N524KCEmanon LLC · Apex, NCBuilt 2004 · S/N 3232030 N5251SHegarty Joseph L · Sioux Falls, SDBuilt 1970 · S/N 32-40954 N5253ALet Industries LLC · Lewes, DES/N 27-7654058 N5255QScott Michael S · Las Vegas, NVS/N 3257212 N5258SPace Aviation LLC · The Woodlands, TXBuilt 1970 · S/N 32-40955

Back to AD 81-12-06 R1