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.

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 N80FFP A M Aviation LLC · Portsmouth, NHBuilt 1972 · S/N 27-7304958 N80GVMoro Aircraft Leasing Inc · Two Rivers, AKBuilt 1975 · S/N 31-7552003 N80LKEti Aviation LLC · Boynton Beach, FLBuilt 1977 · S/N 31-7712103 N80NDMerrifield Robert Craig · Fitzgerald, GAS/N 24-4164 N810KCBlocker Cale · Savannah, GABuilt 1981 · S/N 32R-8129050 N810MJCampbell Fred Cox · Monroe, NCBuilt 1974 · S/N 32-7440082 N8118XSchultz Robert J · Rapid City, SDBuilt 1979 · S/N 32R-8029011 N8118ZWest Metro Aviation LLC · Buffalo, MNBuilt 1979 · S/N 32R-8029013 N811CBRfw Construction Group LLC · Dyersburg, TNBuilt 1974 · S/N 31-7512001 N811PJObrien Neal J · Milton, GABuilt 1969 · S/N 3051 N8124YMatthews Grover C · Hardinsburg, KYBuilt 1966 · S/N 27-3237 N8125DBas Part Sales LLC · Greeley, COBuilt 1979 · S/N 32R-8029014 N8126PCsm Holding LLC · Boscobel, WIBuilt 1963 · S/N 24-3379 N8127ZCrawford Oil Co Inc · Hayti, MOBuilt 1979 · S/N 32R-8029017 N8128BMcguinnis Joseph G · Scottsdale, AZS/N 32R-8029018 N812DKTranscendent Enterprises Inc DBA · Pine Grove, CABuilt 2005 · S/N 3257397 N812MFj Aviation LLC · Texarkana, TXBuilt 2000 · S/N 32-57162 N812MBOeth Laurence B III · Midland, TXBuilt 1997 · S/N 4636111 N812TBTwin Aviation LLC · Coushatta, LABuilt 1981 · S/N 31-8152113 N8137VAeolus Aviation LLC · River Hills, WIBuilt 1980 · S/N 32R-8029003 N8138PFrank Castillo Dds Inc · San Jose, CABuilt 1963 · S/N 24-3392 N81436P&C Construction Inc · Chattanooga, TNBuilt 1979 · S/N 32R-8029045 N8144GDistant Horizons LLC · Park City, UTBuilt 1979 · S/N 32R-8029047 N8148YJustison David L · Hillsboro, ILBuilt 1982 · S/N 32R-8329005 N814CVJam Zoom Yayos LLC · Manheim, PABuilt 2002 · S/N 2137 N814FARivinius Sam · Danville, CABuilt 2003 · S/N T18208214 N81573Jsham LLC · Sheridan, WYS/N 32-8024004 N8158BRegistration Pending · Springfield, MORegistration pendingS/N 32R-8229038 N8158YRobert Lea Investments LLC · Molalla, ORBuilt 1980 · S/N 32-8024006 N8159SGaither David G Executor · Houston, TXS/N 32R-8029059 N8159YRaven Aviation LLC · Murrayville, GABuilt 1980 · S/N 32R-8029060 N815TAS3 Air Aviation LLC · Henderson, NVBuilt 1976 · S/N 32R-7680356 N8165JLloyd J Cleaver D O LLC · Kirksville, MOBuilt 1980 · S/N 32-8024010 N8165RLord David A DBA · Mackay, IDFirst renewal noticeBuilt 1980 · S/N 32R-8029063 N8167DBurch Robert S · Tyler, TXBuilt 1980 · S/N 32R-8029049 N8169ZHarper Hugh Holdings LLC · Alvarado, TXBuilt 1980 · S/N 32-8024012 N816ARCustom Curb Inc · Ventura, CABuilt 2005 · S/N T18208451 N816GHolland Travel Air LLC · Holmen, WIBuilt 1964 · S/N TD-562 N816YPB&D Air Solutions LLC · Austin, TXBuilt 1978 · S/N 32R-7885267

Back to AD 81-12-06 R1