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.

N25PKPacific Fleet Aviation LLC · Rochester, NYBuilt 1977 · S/N 27-7754105 N260CACielo Azul Aviation LLC · Texico, NMBuilt 1975 · S/N 61P-0268-055 N260GCFeline Health Inc · Hampstead, NCBuilt 1969 · S/N 24-4834 N260PCRegistered aircraftBuilt 1965 · S/N 24-4125 N261ERCentral Airlines Inc · Overland Park, KSBuilt 1963 · S/N 1362-133 N261RSNational Aviation Partners LLC · Weatherford, TXBuilt 1972 · S/N 32-7340056 N262ASAerodata LLC · Ann Arbor, MIBuilt 1977 · S/N 31-7712102 N2638ULindsey Aviation Services · Haslet, TXBuilt 1999 · S/N T20608061 N263DHHybird Inc · Corpus Christi, TXBuilt 1982 · S/N 32R-8229067 N263MECommercial Aerial Images Inc · Costa Mesa, CABuilt 2000 · S/N T20608199 N263RCRichland County Sheriffs Department · Columbia, SCBuilt 2013 · S/N T20609107 N264DHPolymath Enterprises LLC · Incline Village, NVBuilt 1981 · S/N 32R-8129095 N264ME618 Aviation LLC · Kosse, TXBuilt 2000 · S/N T20608200 N26509Bell Air LLC · Belleville, KSBuilt 1998 · S/N T2068004 N2650VSampson Merle A · Inver Grove Height, MNBuilt 1998 · S/N T2068005 N2659TLeja Surveying Corp · Yucaipa, CABuilt 1971 · S/N 32-7240036 N2672THilgendorf Blake W · Fairmont, MNBuilt 1971 · S/N 28-7110027 N267JMMathews Development Co · Santa Rosa Beach, FLBuilt 1999 · S/N T20608132 N267RBLearn To Fly LLC · Portal, GABuilt 1967 · S/N 32-40261 N2680QTaylor Clarence J · Pipestone, MNBuilt 1977 · S/N 32R-7780261 N2681TFetty Eric · Burleson, TXBuilt 1971 · S/N 28-7210003 N268HPFlorida Highway Patrol · Tampa, FLBuilt 2005 · S/N T20608579 N269MPGustafson H Clayton · Woodbury, CTBuilt 1980 · S/N 32R8029007 N269ZIziair LLC · Mclean, VABuilt 2006 · S/N 3257407 N26GPGpi Geospatial Inc · Orlando, FLBuilt 1977 · S/N 31-7812001 N26HRiester Bernard J Jr DBA · Auburn, NYBuilt 1998 · S/N 3170 N26JRLerner Lance L · Bozeman, MTBuilt 2000 · S/N 27-0309 N26KMPerformance Aviation Solutions LLC · Meridian, IDBuilt 2001 · S/N T18208051 N26LS J D H LLC · Sewickley, PABuilt 1969 · S/N 32-40877 N26PGSan Angeles Aviation LLC · Phoenix, AZFirst renewal noticeBuilt 1990 · S/N 4622117 N270FBQualitair LLC Trustee · MichelstadtS/N 27-0030 N270MEMm Aviation LLC · Casa Grande, AZBuilt 2000 · S/N T20608213 N270MLWard John L · Mexia, TXBuilt 2002 · S/N 3257297 N271MCSunshine Aero Industries Inc · Crestview, FLBuilt 1967 · S/N 31-175 N271MJGbs Aviation Inc Trustee · Wilmington, DEBuilt 1992 · S/N 27-0127 N27212Koke Edward Trustee · Goleta, CABuilt 2005 · S/N 27-0351 N27272Alpha United Air LLC · Wilmington, DEBuilt 1977 · S/N 31-7712063 N27275Island Wings Inc · Fort Lauderdale, FLBuilt 1977 · S/N 31-7712066 N27299C M B Aviation LLC · Farmington Hills, MIBuilt 1977 · S/N 31-7752128 N27349Valley Airways Inc · Scottsbluff, NEBuilt 1977 · S/N 31-7712087 N273FWeimer Heidi L · Knoxville, TNBuilt 1973 · S/N 32-7340138 N273MJSmith Jeffrey W · Shreveport, LABuilt 1979 · S/N 32R-7985065 N27405N27405 Holding LLC · Palm City, FLBuilt 1977 · S/N 31-7752164 N27418Sun Aircraft Management LLC · Ormond Beach, FLS/N 31-7752169 N27447Laingkids LLC · Lewes, DEBuilt 1977 · S/N 31-7812022 N27449Airchoice LLC · Manchester, IABuilt 1977 · S/N 31-7812025 N27450Flying Oyster Investments II LLC · Apollo Beach, FLBuilt 1977 · S/N 31-7812027 N27471Grant Aviation Inc · Anchorage, AKBuilt 1977 · S/N 31-7852018 N27478Hughes Ronnie D · Cedar Park, TXBuilt 1977 · S/N 31-7852026 N27481Sanborn Map Company Inc · Colorado Springs, COBuilt 1978 · S/N 31-7812009

Back to AD 91-21-01 R1