Skip to content

Registered aircraft · 5,102

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:81-12-06-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:81-12-06-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:81-12-06-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:81-12-06-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:81-12-06-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:81-12-06-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.

N79MEElliott Enterprises Group LLC · Wilmington, DEBuilt 1999 · S/N 232 N7ACCommander Quest LLC · San Luis Obispo, CABuilt 1961 · S/N 500B-1013-34 N7AZDevaney Aviation Inc · Palm City, FLBuilt 1968 · S/N 27-3964 N7CBExperimental Aircraft Association · Oshkosh, WIBuilt 1972 · S/N 27-4802 N7FMAppalachian Racing Aviation LLC · Johnson City, TNBuilt 1971 · S/N 32-7240041 N7HWAltieri Frank J · Somerton, AZBuilt 1967 · S/N 27-3718 N7HXBlairtogaii Inc · Novi, MIBuilt 1982 · S/N 32-8224005 N7JVGreer Air Inc · Saint Cloud, FLBuilt 1971 · S/N 31-789 N7LLBautista Sean P · Reedley, CABuilt 1974 · S/N 310Q1019 N7PQStarr James Trey · Oklahoma City, OKBuilt 1976 · S/N 14096 N7XACine Aviation Inc · W Bloomfield, MIBuilt 1981 · S/N 32R-8229020 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

Back to AD 81-12-06 R1