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.

N610MAThomas Michael J · Malabar, FLBuilt 1966 · S/N 32-40105 N6114XHardy Gareth R · Thatcher, AZBuilt 1960 · S/N 500B-924-9 N6119VN6119v LLC · Boca Raton, FLBuilt 1995 · S/N 14629 N611ADValiair Lc Trustee · Casper, WYBuilt 2003 · S/N T18208196 N611DGMiller Stephen James · Shreveport, LABuilt 1993 · S/N 27-0156 N611DPInversiones Flg Inc · Dorado, PRBuilt 1977 · S/N 31-7812040 N611DWNav Solutions LLC · Lewes, DEBuilt 1961 · S/N 500B-1099-60 N611HMPhysical Systems Inc · Carson City, NVBuilt 1976 · S/N 61P-0290-069 N611WWCone S E Jr · Hobbs, NMBuilt 1978 · S/N 277854093 N6121AMichael Lancy Architect Inc · Glendora, CABuilt 1998 · S/N 20021 N6121YWeaver Scott Allen · North Logan, UTBuilt 1966 · S/N 27-3332 N6124MDiscovery Air LLC · Austin, TXBuilt 2000 · S/N 3257143 N6125YDelaware Aircraft Trust LLC Trustee · New Castle, DES/N 27-3336 N612JSWings Of Eagle LLC · Leo, INBuilt 1970 · S/N 32-40935 N612WWEhecatl LLC · Fort Wayne, INBuilt 1977 · S/N 27-7754114 N612XMexico Medical Missions · Missouri City, TXBuilt 2003 · S/N T18208202 N6137JBradford III Properties LLC · Huntersville, NCBuilt 1976 · S/N 32R-7680309 N6138JLockwood Elijah T · Dayton, OHBuilt 1976 · S/N 32R-7680310 N613DBTigner Steven M · Leesburg, FLBuilt 1999 · S/N 3257091 N613RAKampa Arnold J · Vero Beach, FLBuilt 1966 · S/N 27-3347 N613SMWiff Robert A · Tahuya, WABuilt 1981 · S/N 32R-8129034 N613WKKnaust Jerry L · Blue Jay, CABuilt 1966 · S/N 27-3344 N6140YSouthern Seaplane Inc · Belle Chasse, LAS/N 27-3353 N61430Arias Aviation Inc · Wilmington, DEBuilt 1974 · S/N 31-7401242 N61470White Jerald W DBA · Jackson, TNBuilt 1974 · S/N 31-7401262 N61490Wings Of Hope Inc · Chesterfield, MOBuilt 1975 · S/N 31-7512004 N6149YRobbins Warren N · Chandler, AZBuilt 1966 · S/N 27-3366 N614HMMuhlbach Robert A · Manhattan Beach, CABuilt 1976 · S/N 61P-0306-080 N614KFGreat Ledge Development Inc · Saint Louis, MOBuilt 1977 · S/N 31-7752136 N615HMHill Gerald A · Mesa, AZS/N 61P-0311-082 N615KEDesert & Delta Air LLC · San Francisco, CABuilt 2004 · S/N T20608464 N6161PTse Jeffrey R · Boulder, COBuilt 2005 · S/N T18208384 N6164XRandall Kyle T · Klamath Falls, ORS/N 500B-1012-33 N6164YStriplin James R Jr · Hartford, ALBuilt 1966 · S/N 27-3383 N6168HWayne Air LLC · Collinwood, TNBuilt 1977 · S/N 32R-7880046 N6169YWiesen Enterprises Ltd · Empire, MIBuilt 1966 · S/N 27-3317 N616JPWb Painting Contractors LLC · Greenville, MSBuilt 1967 · S/N 32-40420 N6170YGe Org Advanced Systems LLC · Newton, NJBuilt 1966 · S/N 27-3391 N6171HTyler Cherokee 235 LLC · Lindale, TXBuilt 1977 · S/N 32R-7880047 N6173JMinor Michael W · Summerland Key, FLS/N 32R-7680324 N6173QKinder Mark Edward · Bozeman, MTBuilt 2004 · S/N 18281388 N6174JAloms Enterprises LLC · Marietta, GABuilt 1976 · S/N 32R-7680325 N6179JSanders Jeffrey A · Aurora, COBuilt 1976 · S/N 32R-7680326 N617ECHungerford Brett · Cincinnati, OHBuilt 1975 · S/N 32R-7680096 N617EDMente Charles · Homestead, FLBuilt 1968 · S/N 24-4765 N617ETBunck Richard DBA · Apple Valley, CABuilt 1967 · S/N 32-40205 N6180YChilton Leonard Jay · Caddo Mills, TXS/N 27-3406 N6189YSmith Brian Charles Jr · Lake Mary, FLBuilt 1966 · S/N 27-3415 N618BDSandhu Sky Ventures LLC · Livermore, CABuilt 1989 · S/N 4622047 N618SMHoyle Jason R · Grove, OKBuilt 1975 · S/N 61P-0201-016

Back to AD 91-21-01 R1