Skip to content

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.

N236CMWright Kim B · Anchorage, AKBuilt 1997 · S/N 27-0236 N2370XSouthwest Aircraft Enterprises · Haslet, TXBuilt 1999 · S/N T20608026 N2371HSan Jose Aviation LLC · Mission, TXBuilt 1999 · S/N T20608060 N23781Paragon Air Group · Fort Worth, TXBuilt 1999 · S/N T20608017 N2378XState Of Utah · Salt Lake City, UTBuilt 1999 · S/N T20608023 N2378YLindsey Aviation Services · Haslet, TXBuilt 1999 · S/N T20608025 N2379FWebster Douglas Clark · Las Vegas, NVBuilt 1999 · S/N T20608019 N237REDobbert Thomas · Reno, NVBuilt 2004 · S/N T18208299 N2381YInvictus Investments LLC · Urbandale, IABuilt 1999 · S/N T20608018 N2389GMacon Septic Systems Co Inc · Macon, MSBuilt 2006 · S/N T20608586 N2389LCjw Holdings LLC · Stamping Ground, KYBuilt 2000 · S/N T20608255 N2391EInnova Energy LLC · Wilmington, DEBuilt 1999 · S/N T20608115 N23BQCentral Airlines Inc · Overland Park, KSBuilt 1961 · S/N 500A-1065-46 N23LLAjca Farms LLC · Kalispell, MTBuilt 1975 · S/N 61-0252-100 N23MCFilm Fliers Inc · Orlando, FLBuilt 1976 · S/N 32R-7680190 N23MMAmerica Atlantic Aviation Inc · Stuart, FLBuilt 1967 · S/N 32-40367 N23WBQualitair LLC Trustee · MichelstadtBuilt 1973 · S/N 27-7405281 N2400TAircraft Guaranty Corporation Trustee · Oklahoma City, OKBuilt 2000 · S/N T20608160 N2405MFree Flyers Avionics Inc · Kerkhoven, MNBuilt 1979 · S/N 27-7954049 N240JBMarking Kevin J · Omaha, NEBuilt 1978 · S/N 27-7854108 N2416MSun South Aviation LLC · Wilmington, DEBuilt 1977 · S/N 32R-7880063 N241GTBroshchan Ruslan A · Jackson, MSS/N 2141 N241KRMako Offshore Exploration Inc · Pagosa Springs, COBuilt 2004 · S/N T18208326 N241PBTranstek International Inc · Deerfield, ILBuilt 1964 · S/N 27-2589 N241WFInternational Air Services Inc Trustee · Carson City, NVBuilt 1978 · S/N 31-7852073 N2422UDennissan LLC · Noble, OKBuilt 1979 · S/N 32R-8029002 N242KFTio Pedro P · Miami, FLBuilt 2002 · S/N 3257277 N242RKBas Part Sales LLC · Greeley, COBuilt 1975 · S/N 31-7512025 N242TC182 Flight Corp · Bronx, NYBuilt 2005 · S/N T20608530 N24301Pacific Coast Cycle Corp · Kings Beach, CABuilt 1999 · S/N T20608139 N24337Dunn Craig M · Sarasota, FLBuilt 2000 · S/N 18280713 N2433UEddleman David Baggett · Mclean, VABuilt 2001 · S/N T18208006 N243MCRankin John · Nokomis, FLBuilt 2004 · S/N T18208243 N243PSN9089 LLC · Lewes, DES/N 3257073 N2440PN2440p LLC · Seattle, WABuilt 1999 · S/N T20608136 N2440VVehrs Roger K · Roseburg, ORBuilt 2000 · S/N T20608176 N2441GTognoli Stefano F · Union, ORBuilt 2000 · S/N T20608173 N2441MBlackburn Alan Ryan II · Palm City, FLBuilt 1979 · S/N 27-7954059 N2441YTag Aviation LLC · Santa Teresa, NMBuilt 2000 · S/N T20608169 N2446ESugarloaf Air LLC · Wilmington, DES/N T20608580 N24480Moscair LLC · Nashville, TNBuilt 2001 · S/N 18280932 N244ACScruggs Ken · Galloway, OHBuilt 1968 · S/N 1815-21 N244MEEagle Forestry Services Inc · Monticello, ARS/N T20608192 N244RWeiser Inc · Minburn, IABuilt 1973 · S/N 27-7305025 N24507Pena Jairo · Catharpin, VABuilt 1999 · S/N T20608038 N2454FOlson Donald C · Golovin, AKS/N 27-2666 N2455XRucker Aviation Logistics Inc · Shingle Springs, CABuilt 1999 · S/N T20608121 N24569Pt Logistics LLC · Rye, NHBuilt 2000 · S/N T20608209 N2456HPappusgrass Aviation LLC · San Antonio, TXBuilt 1999 · S/N T20608124 N245AGMummey Jose Pablo · Everett, WAS/N 27-7305187

Back to AD 91-21-01 R1