Registered aircraft · 16,280

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:2008-06-28-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:2008-06-28-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:2008-06-28-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:2008-06-28-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:2008-06-28-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:2008-06-28-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.

N641FTFlorida Institute Of Technology · Melbourne, FLBuilt 2008 · S/N 2842318 N641SR641sr LLC · Greeley, COBuilt 2007 · S/N 2363 N641TSLifewings II LLC · Harrisonville, MOS/N BB641 N641WB3m Ranch LLC · Wittmann, AZBuilt 2006 · S/N 41676 N641WTN641wt LLC · Helena, MTBuilt 2024 · S/N 9913 N6421ZRich Of Peak Aviation LLC · Frisco, TXBuilt 2007 · S/N 42569 N642AJJohnston Andrew · Ottawa, ILBuilt 2022 · S/N 8583 N642CDSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 2005 · S/N 1720 N642CPDodson International Parts Inc · Rantoul, KSBuilt 2009 · S/N 3366 N642FTFlorida Institute Of Technology · Melbourne, FLBuilt 2008 · S/N 2842319 N642JAYale Companies LLC DBA · Indianapolis, INBuilt 2023 · S/N 28020142 N642JF6 Xt LLC · Fort Lauderdale, FLBuilt 2005 · S/N 3255040 N642RGLone Mountain Aircraft Training LLC · Springfield, OHBuilt 2021 · S/N 2760 N642SRSafford Robert Owen Jr · Clarksville, TNBuilt 2006 · S/N 2195 N642TLBuddy Air LLC · West Bend, WIBuilt 2010 · S/N 3642 N643DSDs Air LLC · Jefferson, GABuilt 2006 · S/N 40.643 N643FTFlorida Institute Of Technology · Melbourne, FLBuilt 2013 · S/N 2843703 N643JMSherman Aviation LLC · Haslett, MIBuilt 2003 · S/N 0756 N643LVS&G Sky LLC · Las Vegas, NVBuilt 2020 · S/N 2632 N643MAPritchetts Point LLC · New Castle, INBuilt 2006 · S/N 3246243 N643MFRegistration Pending · Hanceville, ALRegistration pendingS/N 28020121 N643SAStature Aviation LLC · Addison, TXBuilt 2025 · S/N 10461 N643SRSky Dawgs LLC · Kennesaw, GABuilt 2006 · S/N 2136 N643TFFlyway Aviation Partners LLC · Rogers, ARBuilt 2019 · S/N 4796 N644ACTwin Poles Aviation LLC · East Setauket, NYBuilt 2002 · S/N 3449261 N644CDKapp LLC · Dallas, TXBuilt 2004 · S/N 0940 N644DFRegent Trust Corp Trustee · Wichita, KSBuilt 2023 · S/N 2881663 N644DSFitzroy Aviation LLC · San Francisco, CABuilt 2006 · S/N 40.614 N644FTFlorida Institute Of Technology · Melbourne, FLBuilt 2013 · S/N 2843704 N644GKCirrus Design Corp · Duluth, MNS/N 11893 N644KSKent State University · Stow, OHBuilt 2006 · S/N 4496220 N644SAStature Aviation LLC · Addison, TXBuilt 2025 · S/N 10466 N644SRBas Part Sales LLC · Greeley, COBuilt 2006 · S/N 2070 N644STCohen Steven B · Safety Harbor, FLBuilt 2005 · S/N 42079 N645AWHobart Aviation Inc · Akron, OHBuilt 1981 · S/N 28-8116305 N645BDFly 645bd LLC · Louisville, KYBuilt 2005 · S/N 1529 N645CGainous David C · Port Saint Joe, FLS/N 0395 N645CDSkylane LLC · East Hampton, NYBuilt 2004 · S/N 0913 N645CPRjgvb LLC · Shippensburg, PAS/N 3371 N645EMMcdevitt Aircraft LLC · Naperville, ILS/N 1634 N645FTFlorida Institute Of Technology · Melbourne, FLBuilt 2013 · S/N 2843705 N645NDUniversity Of North Dakota · Grand Forks, NDBuilt 2019 · S/N 2881146 N645RSSlack Richard · Highland, UTBuilt 2024 · S/N 9856 N645SRArcangel Aviation II LLC · Kansas City, MOBuilt 2007 · S/N 2645 N645WMBoard Of Trustees Of Western Michigan University · Kalamazoo, MIBuilt 2024 · S/N 9842 N645WTBourne & Bourne Enterprise LLC · Atlanta, GABuilt 2007 · S/N 40.836 N6461CTripacer Strategic Consulting LLC · Dover, DES/N 28-7816425 N6462CA&J Aircraft Leasing Inc · Burlington, COBuilt 1978 · S/N 28-7816426 N6466CConey Island Lunch LLC · Erie, PABuilt 1978 · S/N 28-7890374 N6467CSugden William H · Alexandria, MNBuilt 1978 · S/N 28-7890376

Back to AD 2008-06-28 R1