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.

N2129GNorth Central Marketing Inc · Cranston, RIBuilt 1978 · S/N 32R-7987080 N212GPWibel Enterprises Inc · Crossville, TNS/N 24-3327 N212KMMollet Kern · Massillon, OHBuilt 1996 · S/N 4636052 N21313Foster Peter · University Park, TXBuilt 1978 · S/N 32R-7887200 N2132XChampionx LLC · Sugar Land, TXBuilt 1998 · S/N 27-0250 N2133ASchnack Kenneth L · Crescent, IAS/N 32R-7987007 N21352Lane Shannon L · Hopkinsville, KYBuilt 1978 · S/N 32R-7885252 N21356Elite Financial Management Inc · Dallas, TXBuilt 1978 · S/N 32R-7887202 N21357Wild Outdoors Oil LLC · Velma, OKBuilt 1978 · S/N 32R-7887203 N21372Halbert Ronald S · San Diego, CABuilt 1978 · S/N 32R-7887204 N2137EMbg LLC · Mountain Home, IDBuilt 1997 · S/N 27-0230 N2138BSouthwest Aviation Enterprises · Haslet, TXBuilt 2003 · S/N T20608437 N2138FCima Christopher P · Plano, TXBuilt 1979 · S/N 32R-7987065 N2138KGrigsby Aaron A · Victorville, CABuilt 1978 · S/N 32R-7987070 N2139KPolly P LLC · Fort Worth, TXBuilt 1999 · S/N 27-0271 N213ACRtb Transport LLC · Evans, GABuilt 1984 · S/N 31-8452011 N21406Makushin Logistics LLC · Fairbanks, AKS/N 31-7752117 N21425Nelson Phillip · Jonesboro, ARS/N 32R-7887207 N2142SDbm Farms Inc · Clarksdale, MSBuilt 2003 · S/N T18208224 N21435Car Guys Aviation LLC · Lead, SDBuilt 1978 · S/N 32R-7887210 N21436Smith Michael W · Bracey, VABuilt 1978 · S/N 32R-7887211 N2143BLance Aviation Corp · Houston, TXBuilt 1978 · S/N 32R-7987028 N21459N21459 LLC · Farmington Hills, MIBuilt 1978 · S/N 32R-7887212 N2145RCabernet To Cactus LLC · Scottsdale, AZBuilt 2003 · S/N T20608427 N21469Blubaugh Patrick S · Inyokern, CABuilt 1978 · S/N 32R-7887214 N2148BKaroudjian David · Savannah, GAS/N 32R-7987030 N2148WSav LLC · Shelton, WABuilt 2003 · S/N T20608421 N21493Macmillan Robert J · Merritt Island, FLBuilt 2003 · S/N T20608423 N21494Dmc Air LLC · West Chester, OHS/N 32R-7887216 N21499Kling Clint W · Summerset, SDBuilt 1978 · S/N 32R-7887218 N214BPHolmes Aviation Inc · Webster, FLBuilt 2000 · S/N 3257156 N214HSDelaware Aircraft Trust LLC Trustee · New Castle, DEBuilt 1975 · S/N 27-7654014 N2150BGreen Head Flight Services LLC · Bemidji, MNBuilt 1979 · S/N 32R-7987031 N2150KCarey David John II · Mccall, IDBuilt 2003 · S/N T20608407 N2151YMtjc Services LLC · Chester, WVBuilt 2003 · S/N T18208207 N2153NEagle Air US Inc · Eau Claire, WIBuilt 1979 · S/N 32R-7987096 N2153VGoro Sky Aircraft LLC · Lino Lakes, MNBuilt 1999 · S/N 27-0272 N2154XVital Sync LLC · Lakeway, TXS/N 27-0243 N2155JSlickhorns LLC · Reno, NVS/N T18208209 N2156EMaarouf Dan H · Taylor Village, TXBuilt 1978 · S/N 32R-7987062 N2156NTerryair LLC · Missoula, MTBuilt 2003 · S/N T20608409 N2157NC A R S Sales Inc · Denver, NCBuilt 1979 · S/N 32R-7987097 N2159PKiehn Real Estate LLC · Santa Barbara, CABuilt 2003 · S/N T20608432 N2161AHoyer Chase R · Jarrell, TXBuilt 1978 · S/N 32R-7985003 N2162WHelicopter Applicators LLC · Pembroke, NHBuilt 2004 · S/N T20608439 N2165KAustin David · Cypress, TXBuilt 1999 · S/N 27-0259 N21683Flying H Inc · Hoxie, KSBuilt 1978 · S/N 32-7840188 N2168BBonjour Hugo E · Houston, TXBuilt 1978 · S/N 32R-7987032 N2168FDean William R · Webster Springs, WVBuilt 1999 · S/N 27-0261 N2168JAirgus LLC · Henderson, NVBuilt 1999 · S/N 27-0265

Back to AD 81-12-06 R1