Skip to content

Registered aircraft · 5,086

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:91-21-01-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:91-21-01-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:91-21-01-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:91-21-01-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:91-21-01-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:91-21-01-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.

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 N1548XSouthern Turf Services LLC · West Palm Beach, FLBuilt 1975 · S/N 32-7540172 N15494Freisitzer Roland Franz · Charlottesville, VAS/N 32-7340045

Back to AD 91-21-01 R1