Registered aircraft · 5,086

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:91-21-01-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:91-21-01-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:91-21-01-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:91-21-01-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:91-21-01-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:91-21-01-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.

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 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

Back to AD 91-21-01 R1