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.

N8279YSaratoga Aviation LLC · Sioux Falls, SDBuilt 1980 · S/N 32-8024052 N82813Preside Management Inc · Coachella, CABuilt 1980 · S/N 32-8124001 N8282KNoyes Tony · Lewisville, TXS/N 32R-8129002 N8282NMercury Aircraft Holdings Inc · West Monroe, LABuilt 1980 · S/N 32R-8129003 N8287RHuhnke John · Newburgh, INBuilt 1972 · S/N 32-81 N828BDEchols Mill Aviation LLC · Elberton, GABuilt 1982 · S/N 31-8212017 N828HJPegasus Air Charter LLC · Hartford, CTBuilt 1980 · S/N 31-8052160 N828KTJones Larry · Anchorage, AKBuilt 1980 · S/N 318052098 N828LBBeraut Olivier Trustee · Scotts Valley, CABuilt 1972 · S/N 32-7240077 N828PDSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1991 · S/N 1085 N828SRGulfcoast Aviation Inc · Wilmington, DEBuilt 1978 · S/N 32R-7887169 N82908Hall Charles R · Leawood, KSBuilt 1982 · S/N 32-8324001 N8292TJames Peterson Sons Inc · Medford, WIBuilt 1982 · S/N 32R-8329001 N8299PFischer Dale R · Laporte, INBuilt 1963 · S/N 24-3277 N829CJetran LLC · Horseshoe Bay, TXBuilt 2005 · S/N 3255039 N829MAChambers Reed · Falmouth, MEBuilt 2001 · S/N T18208036 N82FLVan Bortel Aircraft Inc · Arlington, TXBuilt 2001 · S/N 18281007 N82FWRemkes Wolfgang H J Trustee · Gilroy, CABuilt 2001 · S/N T18208027 N82KGBch Real Estate LLC · Eagle, IDBuilt 2005 · S/N T18208440 N82LLSda Aviation LLC · Winnsboro, LABuilt 2000 · S/N 46-36289 N8300JHepper Abby · Keene, NDBuilt 1980 · S/N 32R-8129010 N8301RGotgumbo LLC · Cranberry Township, PABuilt 1982 · S/N 32R-8329002 N8308VCleary Paul D · Guilford, CTBuilt 1980 · S/N 32R-8129016 N830MCArmor Packaging Corp · Piedmont, SCBuilt 1972 · S/N 31-830 N8310PPremiere Aviation Inc · Concord, CABuilt 1963 · S/N 24-3560 N8311CProficient Computing Solutions Corp · Fernandina Beach, FLBuilt 1975 · S/N 32R-7680092 N8311KEnt Flight Services LLC · Santa Margarita, CABuilt 1982 · S/N 32-8324003 N8311NMcallister Joshua R · Gig Harbor, WABuilt 1982 · S/N 32-8324004 N8313PSpencer Cory · Mobile, ALBuilt 1963 · S/N 24-3563 N8314BSchultens Robert R Trustee · The Dalles, ORBuilt 1980 · S/N 32R-8129021 N8314KRed Dirt Retreat LLC · Colorado Springs, COBuilt 1980 · S/N 32R-8129023 N8315HKing 90 LLC · Milwaukie, ORBuilt 1982 · S/N 32-8124028 N8317YG M P Aero Marine LLC · Lauderhill, FLBuilt 1980 · S/N 32-8124005 N83182Devall Kelly · Phoenix, AZBuilt 1982 · S/N 32R-8329011 N831DKKennedy Douglas L · Mountain Lakes, NJBuilt 2005 · S/N T18208361 N831GWAspen Flight Operations LLC · Carbondale, COBuilt 1976 · S/N 61P-0376-122 N8320PCallicrate Michael P · Saint Francis, KSBuilt 1963 · S/N 24-3571 N8322KSmith Gregory L · West Des Moines, IABuilt 1980 · S/N 32R-8129031 N8322LHorizon Aviation Of Myrtle Beach LLC · Myrtle Beach, SCBuilt 1980 · S/N 32R-8129032 N8322PBroken Arrow Crop Insurance Inc · Perryton, TXFirst renewal noticeBuilt 1980 · S/N 32R-8129033 N8323SOdell Ronald W · Peachtree City, GABuilt 1982 · S/N 32-8324005 N8327ZLee Steven M · Redondo Beach, CAS/N 32-8124007 N8328DJldp LLC · Chesapeake, VABuilt 1981 · S/N 32R-8129035 N832TCFour Pines LLC · Grand Rapids, MNBuilt 2003 · S/N 18281269 N8331EPats Sales Of Ocala LLC · Ocala, FLBuilt 1981 · S/N 32-8124008 N8331ULenz Piper LLC · Camdenton, MOS/N 32R-8129037 N8332PGray James Gary · Simpsonville, SCBuilt 1963 · S/N 24-3585 N8333HN8333h LLC · Saint Cloud, MNBuilt 1981 · S/N 32R-8129038 N8333PAllred Klein Enterprise LLC · San Diego, CABuilt 1963 · S/N 24-3586 N8337CStahel Zazell L · Kiana, AKBuilt 1976 · S/N 32R-7680101

Back to AD 81-12-06 R1