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.

N8002PKoerner Aviation Inc · Kankakee, ILBuilt 1962 · S/N 24-3242 N8005KShahan Nathan C · Heath, TXBuilt 1981 · S/N 32-8224003 N8005PAcklam David C · Yelm, WABuilt 1962 · S/N 24-3245 N8006JCrimson Star LLC · Virginia Beach, VABuilt 1981 · S/N 27-8154009 N8006QBramley Eric M · Avondale Estates, GABuilt 1981 · S/N 32R-8213016 N800DKBartlett Paul H · Nebo, NCBuilt 1976 · S/N 31-7612110 N800HSVertical Horizon Aviation LLC · Sandown, NHBuilt 2001 · S/N 3257246 N800LPC A Aviation Corp · Clifton, TXBuilt 1983 · S/N 31-8352009 N800MSMcghee John M · Breckenridge, COBuilt 1991 · S/N 270107 N800MWNorpel Express LLC · New Bedford, MABuilt 1981 · S/N 31-8252011 N8016PSteelera Aviation LLC · Wolfforth, TXBuilt 1962 · S/N 24-3260 N801CHRisse Greg L · Lincoln, CABuilt 1974 · S/N 31-7405460 N801DPSunset Aviation Services LLC · Coeur D Alene, IDBuilt 1960 · S/N 500B-999-30 N801KPlumlee James H · Bluffton, SCBuilt 1961 · S/N 500B-1094-57 N801PCGrand Michael · Palacios, TXBuilt 1965 · S/N 24-4256 N8021ULundell Brad · Kiron, IABuilt 1981 · S/N 28-8211020 N8023PShisier William · Tempe, AZBuilt 1962 · S/N 24-3267 N8024YValiair Lc Trustee · Casper, WYBuilt 1981 · S/N 32R-8229018 N8025JTorres Rafael · San Juan, PRBuilt 1978 · S/N 60-0503-163 N8028PTrest Robert J · Pelzer, SCBuilt 1962 · S/N 24-3274 N802GAMns Asset Management LLC · Dover, DEBuilt 1981 · S/N 31-8152103 N802SDFly Blew LLC · Fayetteville, ARBuilt 2004 · S/N T18208239 N8033RGoodson Aviation LLC · Tallahassee, FLS/N 31-7952065 N8041HKing Ag Leasing Inc · Sudan, TXBuilt 1981 · S/N 32R-8229022 N8041MLewis Edward H · Moorestown, NJBuilt 1981 · S/N 32R-8229023 N8042GTemple In The Sky LLC · Marietta, GABuilt 1981 · S/N 32R-8229024 N8043PGray Motors Inc · Port Angeles, WABuilt 1962 · S/N 24-3289 N8047SRisso Christopher W · Huntington Beach, CABuilt 1981 · S/N 32R-8229025 N8052PCornerstone Dec Ltd · Chico, CABuilt 1962 · S/N 24-3298 N805NJFreedom Capital Air LLC · Winchester, TNBuilt 1980 · S/N 31-8052109 N8062TDitullio Peter C · Fallbrook, CABuilt 1981 · S/N 32R-8229027 N8063MFriar Aerospace Group LLC · Jacksonville, FLBuilt 1978 · S/N 31-7852023 N8065JHerlihy John Joseph · Arroyo Grande, CABuilt 1978 · S/N 61P-0548-234 N8067JCc Air LLC · Orchard, NES/N 60-0550-178 N8067PShreve Jerry L · Warrensburg, MOBuilt 1962 · S/N 24-3314 N8069SGates Joel L · Salida, COBuilt 1981 · S/N 32R-8229028 N80702Over The Numbers LLC · Churchville, PABuilt 1981 · S/N 32R-8229030 N807ABSunward Aviation Services LLC · Merritt Island, FLS/N 31-8152183 N807FPM&A Industrial Construction LLC · Atkinson, NEBuilt 1977 · S/N 32R-7780518 N8087EJd Aviation Inc · Muskegon, MIBuilt 1979 · S/N 32R-8029019 N808ABSunward Aviation Services LLC · Merritt Island, FLS/N 31-8052128 N808DLSons Aviation Inc · Moody, ALBuilt 1967 · S/N 32-40309 N808DTGh Aircraft Leasing LLC · Coconut Creek, FLBuilt 2001 · S/N T20608278 N8090TN8090t LLC · Austin, TXBuilt 1979 · S/N 32R-8029020 N8095PGramas Illya W · Shelby, MIBuilt 1962 · S/N 24-3344 N8096JBullgoose Aviation Inc · York, PANon-citizen corporation, flight hours not reportedBuilt 1979 · S/N 32R-8029006 N8097CImmell Michael · Buffalo, OKBuilt 1975 · S/N 32-7640052 N809BWGilly Christian · Newtown, PABuilt 2005 · S/N 27-0334 N809DWReed Land & Properties LLC · Kalispell, MTBuilt 2002 · S/N T18208109 N80DECampbell Bradford D · Groton, CTBuilt 1973 · S/N 74-31083

Back to AD 91-21-01 R1