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.

N765Moby Partnership · Albuquerque, NMBuilt 1975 · S/N 61P-0271-057 N7651HGosbrook Aviation LLC · Lewes, DEBuilt 1973 · S/N 32-7440025 N7655FShining Star Aviation LLC · Zephyr Cove, NVBuilt 1976 · S/N 32-7740015 N765KPMarc Inc · Bolton, MSBuilt 1982 · S/N 31-8253012 N765LMLangdon Adam · Omaha, NEBuilt 1999 · S/N 27-0269 N7669VYpma Gene A · Harrison, MTBuilt 1968 · S/N 1397 N766CFAirplane Five LLC · Miami, FLBuilt 1973 · S/N 31-7305102 N766VKWave Golf LLC · Kimberly, ALBuilt 1977 · S/N 32R-7780271 N7671FPedal Valves Inc · Luling, LABuilt 1976 · S/N 32-7740016 N7678VHinckley David D · Belton, TXBuilt 1968 · S/N 1406 N767CVNcv LLC · Jacksonville, FLBuilt 2001 · S/N 3257234 N767RJS&S Aircraft Inc · Bennington, VTBuilt 1964 · S/N 27-2651 N767SCClegg Stephen A · Port Orange, FLBuilt 1977 · S/N 27-7754060 N7688Jte Properties LLC · Azle, TXBuilt 1996 · S/N 4636055 N768PEMts Inc · Middletown, DEBuilt 1977 · S/N 31-7712037 N7692FCwh Properties LLC · Falls City, NES/N 32R-7780080 N7694LLowell Darryl S · Anchorage, AKBuilt 1973 · S/N 31-7305024 N7696VBoeing Co · Renton, WABuilt 1968 · S/N 1424 N7698C98charlie LLC · Van Wert, OHBuilt 1975 · S/N 32R-7680059 N769GSSkylar Aviation LLC · Hagerhill, KYBuilt 1977 · S/N 32R-7780236 N769LZMontana 1204 LLC · Rock Valley, IABuilt 2003 · S/N 3255012 N76AWPacific Fleet Aviation LLC · Rochester, NYBuilt 1975 · S/N 27-7554100 N76EHMitchell Matthew J · Penn Yan, NYBuilt 1975 · S/N 32R-7680034 N76FR76 Freedom LLC · Greenville, INBuilt 1977 · S/N 32R-7780317 N76JNGross Charles C III · Mims, FLBuilt 1976 · S/N 31-7652176 N770BHFernando Baeza · Anthony, NMBuilt 2005 · S/N 27-0342 N770BKHorizon Dreams LLC · Homer, GABuilt 1969 · S/N 27-4296 N770KTInterprime Air Inc · Doral, FLBuilt 1975 · S/N 31-7552053 N7711MStauffer Michael S · Wichita Falls, TXBuilt 1965 · S/N 27-2936 N7712FRice Robert Dalton · Kerrville, TXBuilt 1976 · S/N 32R-7780082 N7716PWhite Donald R · La Ward, TXFirst renewal noticeBuilt 1962 · S/N 24-2929 N771LMBruntjen Eric · Decatur, ILBuilt 1982 · S/N 32R-8229044 N7729VNew England Soaring Tug LLC · Perkinsville, VTBuilt 1969 · S/N 1480 N772DLClik Services LLC · Forestdale, MABuilt 1981 · S/N 318152007 N772DSCharleston Aviation Inc · Charleston, ILBuilt 2002 · S/N 4636338 N772SDWallace Robert L II · Anderson, SCBuilt 1978 · S/N 32R-7887246 N7735PVickers Tim F · Huntingdon, TNBuilt 1961 · S/N 24-2949 N773HPFlorida Highway Patrol · Tallahassee, FLBuilt 2000 · S/N T20608180 N773JSRjb Aviation LLC · Newark, DEBuilt 1989 · S/N 4622073 N773PTRegent Trust Co Trustee · Wichita, KSBuilt 1973 · S/N 27-7305144 N7742VNorbury Ross · Boonville, MOBuilt 1969 · S/N 1495 N774FSHilty Kenneth C · Greensboro, NCBuilt 2000 · S/N 3257192 N775DSFlight Ventures LLC · Charlotte, NCS/N T18208498 N775RAMojave 775ra LLC · Roseburg, ORBuilt 1982 · S/N 31P8414038 N775TSSmith Paul A · Trufant, MIBuilt 1976 · S/N 27-7654069 N7761VLangley Richard A · Sheyenne, NDBuilt 1969 · S/N 1518 N7772HGws Contractors Inc · Bonne Terre, MOBuilt 2004 · S/N T18208257 N7772VHauser Linda L · Ulysses, KSBuilt 1969 · S/N 1515 N7772WWadhwa Anil Jethanand · Clarksville, TNBuilt 2004 · S/N 18281336 N7774VMarshall Soaring Club Inc · Marshall, MIBuilt 1969 · S/N 1528

Back to AD 91-21-01 R1