Skip to content

Registered aircraft · 5,075

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:84-19-03-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:84-19-03-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:84-19-03-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:84-19-03-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:84-19-03-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:84-19-03-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.

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 N5259SSquier Robert J · Royal Oak, MIBuilt 1970 · S/N 32-40939 N525JFMoray Eel LLC · Vail, AZS/N 24-4905 N525MGN525mg LLC · Menlo Park, CABuilt 1999 · S/N 3257118 N5262SSalls Robert A · Glen Mills, PABuilt 1971 · S/N 32-7140040 N5263TBackroads Aviation LLC · Holdrege, NEBuilt 1972 · S/N 32-7240102 N52657Honeycutt Holdings Inc · Charlotte, NCS/N T18208172 N5265SEagle Aeronautics LLC · Chicago, ILBuilt 1971 · S/N 32-7140044 N526AWRegistration Pending · Shell Lake, WIRegistration pendingBuilt 1977 · S/N 14226 N526JMFaith-Full Family Finances Inc · Mount Vernon, OHBuilt 1994 · S/N 4622166 N526VRR V Aviation LLC · Thatcher, AZBuilt 1964 · S/N 1424-150 N52715Echo Sierra 54 LLC · Hagerstown, MDBuilt 2002 · S/N T18208174 N52766Krobkrua Tio LLC · Snowflake, AZBuilt 2003 · S/N T20608398 N5276YPadlock Ranch Co · Ranchester, WYBuilt 2002 · S/N T18208176 N527TBN527tb LLC · Missoula, MTBuilt 1998 · S/N 4636166 N5287SBas Part Sales LLC · Greeley, COS/N 27-0244 N5295THayley Douglas Aviation Inc · Auburn, ALFirst renewal noticeBuilt 1972 · S/N 32-7240104 N529ECAlpha Tango LLC · Little River, SCBuilt 1975 · S/N 32R-7680072 N529PTLt Express LLC · Carson City, NVBuilt 2002 · S/N T18208119

Back to AD 84-19-03 R1