Skip to content

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.

N4LGHmt Leasing LLC · Seabrook, TXBuilt 2001 · S/N FL-326 N4YSRegistered aircraftBuilt 1992 · S/N FL-82 N50Textron Aviation Inc · Wichita, KSS/N FL-1375 N500PBLegendary Air LLC · Destin, FLBuilt 2006 · S/N FL-514 N500SEPjh Consulting LLC · Reno, NVBuilt 1994 · S/N FL125 N500VLAir Walker LLC · Virginia Beach, VAS/N FL-383 N503DETvpx Trust Co LLC Trustee · North Salt Lake, UTBuilt 2016 · S/N FL-1051 N503LMBig Sky LLC · Draper, UTBuilt 1997 · S/N FL-182 N504SVLa Babia K A LLC · San Antonio, TXBuilt 2015 · S/N FL-1025 N5055JFlorida State Guard · Tallahassee, FLBuilt 2013 · S/N FL-855 N505SGBank Of Utah Trustee · Salt Lake City, UTBuilt 2008 · S/N FL-606 N506KBLasai Aviation LLC · Reston, VABuilt 2006 · S/N FL-506 N506MVFirecracker Air LLC · Missoula, MTBuilt 1999 · S/N FL-261 N50JDMillennium Aviation New York LLC · Rochester, NYBuilt 2018 · S/N FL-1149 N51Textron Aviation Inc · Wichita, KSS/N FL-1378 N511DGarmin International Inc · Olathe, KSBuilt 1997 · S/N FL-172 N512DCRegistered aircraftBuilt 2002 · S/N FL-342 N512MEBridger Aerospace Group Holdings LLC · Belgrade, MTBuilt 1991 · S/N FL-61 N514DHAirprop Inc · Portsmouth, NHBuilt 2021 · S/N FL-1250 N517KDepartment Of Homeland Security · Washington, DCBuilt 2015 · S/N FM-65 N52Textron Aviation Inc · Wichita, KSS/N FL-1379 N524PCKlingaman Katherine R · Dallas, TXS/N FL-447 N525DFBleu Cheese Aviation II LLC · Addison, TXBuilt 2000 · S/N FL-306 N53Textron Aviation Inc · Wichita, KSS/N FL-1381 N530SRDavis & Floyd Aviation LLC · Greenwood, SCBuilt 2015 · S/N FL-991 N531BXMcguire Aviation LLC · Post Falls, IDBuilt 2018 · S/N FL-1154 N538ATAirtrex Registration Corp Trustee · Wichita, KSS/N FL-736 N539ATAirtrex Registration Corp Trustee · Wichita, KSS/N FL-834 N53CVExecutive Air Taxi Corp · Bismarck, NDS/N FL101 N53KGKentucky State Police · Frankfort, KYBuilt 2021 · S/N FL-1246 N54Textron Aviation Inc · Wichita, KSS/N FL-1383 N541GDepartment Of Homeland Security · Washington, DCBuilt 2018 · S/N FM-74 N541WATextron Aviation Inc · Wichita, KSS/N FM-145 N544BHCrossroad Aviation LLC · Dover, DEBuilt 2021 · S/N FL-1254 N545KAVette Collect Aviation LLC · East Moline, ILBuilt 2007 · S/N FL-545 N546YRLindsey Aviation Services · Haslet, TXBuilt 1997 · S/N FL-162 N547PAcqr Leasing LLC · Lake Shore, MNBuilt 1997 · S/N FL185 N549ARAcademy Resources LLC · Taos, NMBuilt 2003 · S/N FM11 N55Textron Aviation Inc · Wichita, KSS/N FL-1388 N555ALMcgraw Aviation LLC · Lees Summit, MOS/N FL-360 N557APAtlantic Transportation Of Wilmington LLC · Wilmington, NCBuilt 2013 · S/N FL-879 N557SCInnovative Aviation LLC · Summerville, SCBuilt 2014 · S/N FL-929 N558BVDt Air LLC · Picayune, MSBuilt 1998 · S/N FL-223 N559KAN559ka LLC · Las Vegas, NVBuilt 2026 · S/N FL-1364 N559LAPs&B LLC · Los Angeles, CABuilt 2019 · S/N FL-1207 N56Textron Aviation Inc · Wichita, KSS/N FL-1390 N561AUS Department Of Homeland Security · Washington, DCBuilt 2010 · S/N FM-36 N5626YHillcrest Air LLC · Jackson, TNBuilt 1991 · S/N FL-43 N5655KYellow Airplane LLC · Columbus, NEBuilt 1990 · S/N FL-12 N568DRDordick Law Corp · Beverly Hills, CABuilt 2019 · S/N FL-1176

Back to AD 91-20-14 R1