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.

N21722Western Properties Investors And Advisors LLC · Laguna Niguel, CABuilt 2004 · S/N T18208261 N21727Centennial Corp · Reno, NVBuilt 1979 · S/N 32R-7887227 N2172BBenesh Mark L · Punta Gorda, FLBuilt 1978 · S/N 32R-7987034 N2172JTaylor A Pharr Esq LLC · Alexander City, ALBuilt 2004 · S/N T18208250 N21744Oatdog Aviation LLC · Atlanta, GABuilt 2004 · S/N T18208255 N21746Sky West Aviation Inc Trustee · Albuquerque, NMBuilt 2005 · S/N T18208462 N2175ACrawford Garrett Ross · Artesia, NMBuilt 1979 · S/N 32R-7987012 N2175WIndustry Machine Design & Automation Inc · Camarillo, CABuilt 2005 · S/N T18208463 N2176LBixler David L · Lake Forest Park, WABuilt 1999 · S/N 27-0263 N2176STango-Alpha LLC · Saint Charles, MOBuilt 2004 · S/N T18208256 N2176VAspen Avionics Inc · Phoenix, AZBuilt 1979 · S/N 32R-7987116 N2177JPlane Skies Aviation · Cedar, MNBuilt 2000 · S/N 27-0286 N21796Seegmiller Geoffrey · Houston, TXBuilt 2004 · S/N T18208329 N2179MKairez Carolyn E · Punta Gorda, FLBuilt 2005 · S/N T18208466 N217DLValiair Lc Trustee · Casper, WYS/N T20608224 N217TSLaukatel Air Inc Trustee · Wilmington, DEBuilt 1998 · S/N 4636144 N2181AL&C Ventures LLC · Clovis, NMBuilt 2005 · S/N T18208467 N21825Shepherd David K J · Bakersfield, CABuilt 1978 · S/N 32-7840189 N2182KDura Built LLC · Greensburg, KYBuilt 2005 · S/N T18208469 N2182VJavorsek Daniel II · Harriman, TNS/N 32R-7987117 N2183PBarney Northcote Inc · Riverside, CABuilt 2005 · S/N T18208470 N2183VMile High Maintanance Inc · Lakewood, COBuilt 1979 · S/N 32R-7987118 N2186ZNational Products Inc · Seattle, WABuilt 2005 · S/N T20608559 N21873Orourke Daryl J · Oak Lawn, ILBuilt 1978 · S/N 32R-7885264 N21892Dove Aviation LLC · Greensboro, GABuilt 1978 · S/N 32R-7887237 N21899Southern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1978 · S/N 32R-7887239 N2190BVeritas Aero LLC · West Lafayette, INBuilt 1978 · S/N 32R-7985014 N2191BPetersburg Flying Service LLC · Petersburg, NEBuilt 1978 · S/N 32R-7985015 N2193GWestward Aviation · Boulder, COBuilt 2000 · S/N 27-0294 N2196LAerolisse LLC · Chouteau, OKBuilt 2005 · S/N T18208478 N219DL3 Wolfpack Sigma LLC · Overland Park, KSBuilt 1999 · S/N 4636209 N219SDFreund Gregor · San Francisco, CABuilt 2001 · S/N 2050 N21ABAriel J Quintela LLC · Odessa, FLBuilt 1980 · S/N 31-8052122 N21AGGronemeyer Jens · Deland, FLS/N 4636106 N21AQCapiga Daniel P · North Fort Myers, FLBuilt 1973 · S/N 27-7305035 N21HGDrisco LLC · Ponca City, OKBuilt 1981 · S/N 31-8152078 N21HLChieftain Aviation Inc · Marietta, GAS/N 31-8152126 N21NCBearing Tree Land Surveying LLC · Oklahoma City, OKBuilt 1976 · S/N 27-7654012 N21VTCle Aviation LLC · Palm Beach Gardens, FLBuilt 1974 · S/N 60-0185-082 N21WDMullens Aviation LLC · Estero, FLBuilt 1975 · S/N 60-0197-087 N2202NAlcyone Trust Corp Trustee · Wichita, KSBuilt 2005 · S/N T20608562 N2205PSignature Properties Of Litchfield Inc · Murrells Inlet, SCBuilt 1979 · S/N 32R-7985079 N2208ALance Eight Alpha LLC · Terre Haute, INBuilt 1978 · S/N 32R-7985005 N2209TSngdo Aviation LLC · Spring Hill, FLBuilt 1971 · S/N 32-7140070 N220BCRock Creek Leasing LLC · Sapulpa, OKS/N 61-0031 N220LLife Chiropractic And Wellness Center Inc · Prudenville, MIBuilt 1977 · S/N 32R-7780393 N220RMBenner Gregory T · Youngsville, NCBuilt 1978 · S/N 32R-7887161 N220WJaw Air LLC · Fargo, NDS/N 4622052 N2210QSymphony Air LLC · Medford, NYBuilt 1977 · S/N 32R-7780234 N22117Von Ahlefeldt Alan R · Parker, COBuilt 1978 · S/N 32R-7887244

Back to AD 91-21-01 R1