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.

N146JMarc Inc · Bolton, MSBuilt 1977 · S/N 31-7852005 N146NCHills Jason · Bothell, WABuilt 1998 · S/N 4636176 N14702Cartel Oil Records LLC · Kansas City, MOBuilt 1973 · S/N 74-32-136 N1470BBerger Leo · Nampa, IDS/N 31-7512061 N14714Poco Loco LLC · Mesa, AZBuilt 1973 · S/N 74-31084 N14734Thorman Bryan R · Grand Junction, COBuilt 1974 · S/N 75-32-154 N14746Kashiwa Charles · Glens Falls, NYS/N 75-32-156 N14747Hausken Matthew · Centuria, WIBuilt 1973 · S/N 73-31071 N1474TStella Stephen G DBA · Fort Lauderdale, FLBuilt 1972 · S/N 32-7240125 N14758Jim Franklin Aviation Service Inc · Ruidoso, NMBuilt 1974 · S/N 74-32-141 N147AJAviation Solutions LLC · Louisville, KYBuilt 2006 · S/N T18208482 N147FBrown Helicopter Inc · Pensacola, FLBuilt 1964 · S/N 1432-152 N147PJVargas Luis A · Isabela, PRBuilt 1972 · S/N 32-7240134 N1483CWang Helin · Dana Point, CABuilt 2005 · S/N T18208419 N1485CLiebowitz Alan · Sioux Falls, SDBuilt 2005 · S/N T18208421 N148GHLattimore Partners LLC · Fort Worth, TXBuilt 2005 · S/N T18208417 N148JMTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2000 · S/N 2020 N148RFPaklook Air Inc · Bethel, AKBuilt 1976 · S/N 32R-7680076 N149ABVarga Miklos · Helendale, CABuilt 2005 · S/N T18208372 N149PCSubick Leonard · Spring City, PABuilt 1966 · S/N 27-3534 N14APGlobal Air Concepts LLC · Anchorage, AKBuilt 1977 · S/N 31-7752060 N14DWBurnett Timothy S · Birmingham, ALS/N 32R-7887023 N14GSKerner Robert · La Vergne, TNBuilt 1971 · S/N 27-4637 N14PCAlooment LLC · Las Vegas, NVBuilt 1989 · S/N 4622027 N14SFArnold Kiefer · East Prairie, MOBuilt 1973 · S/N 74-32-131 N14SGBorts Gerald S · Altadena, CABuilt 1978 · S/N 14434 N14YPHubbard Scott Edward Jr · Deatsville, ALBuilt 1962 · S/N 24-3246 N1501TRegistered aircraftBuilt 1972 · S/N 32-7240127 N15036Avocation Aviation Inc · Muncie, INBuilt 1972 · S/N 32-7240136 N15040Foote Samuel Henry Trustee · Paradise Valley, AZBuilt 1972 · S/N 327240137 N150FCHart John Jr · Vallejo, CABuilt 1992 · S/N 27-0139 N1512FJordan S G · Wasilla, AKBuilt 1965 · S/N 185-0833 N1512X4js Inc DBA Great Country Motors · Sun City, AZS/N 32R-7680002 N15137Cart Caleb L · Eunice, LAS/N 32-7340016 N15172Transit William B · Macomb Township, MIBuilt 1972 · S/N 32-7340018 N15198Kehl Bryan R · Moorpark, CABuilt 1972 · S/N 32-7340020 N151LTBoss Dog LLC · Sheridan, WYBuilt 1963 · S/N 1316-125 N151PAIntermountain Fabrication LLC · Jerome, IDBuilt 2003 · S/N T18208186 N151STWildman Lake Lodge Inc · Anchorage, AKBuilt 1979 · S/N 31-8052036 N15238Shme II LLC · West Lakeland, MNBuilt 1972 · S/N 32-7340024 N15240Mitchell Joseph B · Westfield, MABuilt 1972 · S/N 32-7340025 N15268Jj Freefall Inc · Wendell, NCBuilt 1972 · S/N 32-7340029 N15293Dionisio Phillip · East Moriches, NYBuilt 1972 · S/N 32-7340033 N152SWDjct LLC · Brown Summit, NCBuilt 1981 · S/N 28-8211017 N15316Drmm Aviation LLC · South Beloit, ILBuilt 1972 · S/N 32-7340036 N1535XSmith James E · Wilson, NCBuilt 1975 · S/N 32-7540170 N153EJQualitair LLC Trustee · MichelstadtBuilt 1983 · S/N 31P-8414011 N153LMSkylens LLC · Hammond, LABuilt 1976 · S/N 27-7754019 N153WBOster Dale E · Trego, MTBuilt 1966 · S/N 27-3329 N1541XSheffer Marshall A · Herrin, ILBuilt 1975 · S/N 32-7540171

Back to AD 81-12-06 R1