Registered aircraft · 784

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-20-14-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-20-14-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-20-14-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-20-14-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-20-14-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-20-14-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.

N40GZAirtrex Aircraft Alpha Inc · Wichita, KSBuilt 2004 · S/N FL-400 N410CDepartment Of Homeland Security · Washington, DCBuilt 2020 · S/N FM-85 N410LKBeachview Aviation LLC · Wilmington, DEBuilt 2009 · S/N FL-669 N411GCWb Air2021 LLC · Cochran, GABuilt 1997 · S/N FL163 N411WCBpi LLC · Maple Lake, MNBuilt 2007 · S/N FL-571 N412CBGwvk LLC · Kansas City, KSS/N FL-440 N412GDepartment Of Homeland Security · Washington, DCBuilt 2019 · S/N FM-78 N416NHBruair LLC · Clive, IABuilt 2008 · S/N FL-602 N4170NBank Of Utah Trustee · Salt Lake City, UTS/N FL-270 N419HFPvm Aviation LLC · Wilmington, DEBuilt 2017 · S/N FL-1121 N419KDepartment Of Homeland Security · Washington, DCBuilt 2015 · S/N FM-64 N41SUTextron Aviation Inc · Wichita, KSS/N FM-141 N41WCOliver Stanbery Orthopedics LLC · Louisville, KYBuilt 2016 · S/N FL-1065 N420EMRegional Logistic Missions LLC · Mobile, ALS/N FL-487 N421BDepartment Of Homeland Security · Washington, DCBuilt 2019 · S/N FM-81 N427BCMma Air Travel Services LLC · Brownfield, TXBuilt 2008 · S/N FL-581 N427JSLiechty Automotive Management LLC · Gulf Breeze, FLBuilt 1999 · S/N FL-263 N431DCDiesel Acquisitions LLC · Milpitas, CAS/N FL-431 N432PKX-Press Charter Services Inc · Longview, TXBuilt 1990 · S/N FL30 N434ZTZimin Transportation LLC · South Naknek, AKBuilt 2007 · S/N FL-561 N4380YRichards Aviation LLC · Gadsden, ALS/N FL-280 N43BGRight Brothers LLC · San Clemente, CABuilt 1994 · S/N FL-117 N43RSWdr Aviation LLC · Midland, TXBuilt 2005 · S/N FL-443 N44NDGrand Air LLC · Missoula, MTBuilt 2015 · S/N FL-998 N450CKCeekay Leasing LLC · Fort Worth, TXS/N FL-464 N450CRTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2002 · S/N FL-340 N452TBU S Special Operations Command · Macdill Afb, FLBuilt 2009 · S/N FL-623 N454GCUniversity Of South Carolina · Columbia, SCBuilt 2012 · S/N FL-789 N454LFJamm Aviation Inc · Columbus, OHBuilt 1998 · S/N FL-209 N454TBDepartment Of Public Safety Of The State Of Texas · Austin, TXBuilt 2007 · S/N FL-554 N4587RIntercoastal Aviation · Fort Lauderdale, FLS/N FM-13 N466YAZimin Transportation LLC · South Naknek, AKS/N FL-662 N46KASouthern Ionics Inc · West Point, MSBuilt 2021 · S/N FL-1281 N46WDCdg Express LLC · Hernando, MSBuilt 1991 · S/N FL-38 N470KAKerola Aviation Inc · Masury, OHBuilt 1993 · S/N FL-109 N472JLFreelance Air · Kennesaw, GABuilt 2011 · S/N FM-50 N476PBAerotrust Services Corp Trustee · Wilmington, DEBuilt 2015 · S/N FL-1032 N478LDSouthwest Aviation Enterprises · Haslet, TXBuilt 1992 · S/N FM-5 N479BCm Aviation LLC · Corsicana, TXBuilt 2002 · S/N FL-338 N479WBFlyguys Aviation II LLC · Midland, TXBuilt 2007 · S/N FL517 N47CRCrc Air LLC · Kenner, LAS/N FL-407 N48Federal Aviation Administration · Oklahoa City, OKBuilt 2024 · S/N FL-1347 N480EB2020 Drt350 LLC · Lufkin, TXBuilt 2008 · S/N FL-600 N487SFTexas Pacific Land Corp · Dallas, TXBuilt 2017 · S/N FL-1123 N49Textron Aviation Inc · Wichita, KSBuilt 2026 · S/N FL-1362 N495DHRedwood Management LLC · Santa Rosa, CABuilt 2004 · S/N FL-404 N4982RParagon Air Group · Fort Worth, TXBuilt 1998 · S/N FL-224 N498RKCbcc King Air Inc · Bakersfield, CABuilt 2023 · S/N FL-1324 N49WCWest Coast Aircraft Shares LLC · Santa Ana, CABuilt 1996 · S/N FL-144 N4KFAirkap LLC · Sioux City, IABuilt 2002 · S/N FL-354

Back to AD 91-20-14 R1