Registered aircraft · 16,290

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.

N115TWYale Companies LLC DBA · Indianapolis, INBuilt 2023 · S/N 28020133 N115UVUtah Valley University · Orem, UTBuilt 2020 · S/N 40.1222 N115YSTunnell Darrell · Visalia, CABuilt 1974 · S/N LW126 N1160UPiper Aircraft Inc · Vero Beach, FLBuilt 2025 · S/N 28020245 N1161VDesert Pine Aviation LLC · Scottsdale, AZS/N 41749 N116AVValleortiz Hector J · Laurel Hill, NCBuilt 1984 · S/N 28-8416094 N116FTGreenhill Stacey · Lincolnshire, ILBuilt 2008 · S/N 411112 N116KWE2e4 Labs LLC · Wilmington, DEBuilt 2003 · S/N 0732 N116UVUtah Valley University · Orem, UTBuilt 2020 · S/N 40.1223 N1170BHooper Jonathan · Andrews, NCS/N 42563 N11770Cirrus Design Corp · Duluth, MNS/N 11770 N117BCGiardina Edward Charles Jr · Cranston, RIBuilt 1977 · S/N 28-7790565 N117BKBravo Kilo Capital LLC · Naples, FLBuilt 2021 · S/N 4999 N117BMManeck Aviation LLC · Columbus, GABuilt 1997 · S/N 46-36078 N117CSSam Airlines LLC · Wilmington, DEBuilt 1996 · S/N 32-46024 N117DBHawley Vance L · Idaho Falls, IDBuilt 1979 · S/N 28-7990284 N117FDTush Mason Lee Jr · Sarasota, FLBuilt 2023 · S/N 9081 N117FPCross Timbers Holdings LLC · Dover, DEBuilt 2007 · S/N 42553 N117GFive Bros Transportation LLC · Hobbs, NMBuilt 2009 · S/N 3464 N117GHAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2001 · S/N 3257217 N117HCHm Aviation LLC · Lake Wales, FLBuilt 2025 · S/N 10640 N117HWYale Companies LLC DBA · Fishers, INBuilt 2026 · S/N 2881998 N117KCElektra Air LLC · New York, NYBuilt 2017 · S/N 4536 N117KDCirrus Pompano Flyers Inc · Fort Lauderdale, FLBuilt 2000 · S/N 1072 N117KRFox Planes LLC · Sterling Heights, MIBuilt 1997 · S/N 4636088 N117LFD&E Aircraft LLC · Newark, OHBuilt 2012 · S/N 2148 N117MMlp Recreation LLC · Lewes, DEBuilt 2023 · S/N 9249 N117NURegistered aircraftBuilt 1998 · S/N 4636138 N117PWCommand Air LLC · Arlington, VABuilt 2001 · S/N 4697030 N117SEHalsell Jason · Wolfforth, TXBuilt 2004 · S/N 3255017 N117SMSo Lucky Two LLC · Wilmington, NCBuilt 2023 · S/N 9072 N117TKWindstar Air LLC · Carroll, IABuilt 1979 · S/N 28-7990546 N117VRAtmospheric Vehicle & Spacecraft Flght Exploration · Rch Palos Vrd, CABuilt 1968 · S/N 28R-30443 N118ARAr Ariel · Fort Lauderdale, FLBuilt 2011 · S/N 3772 N118ATAirline Transport Professionals Corp Of USA · Wilmington, DEBuilt 2000 · S/N 4496034 N118BJOn Final Aviation LLC · Brookland, ARBuilt 1977 · S/N 28-7890125 N118CHSandstrom Brent B · Gilbert, AZBuilt 2014 · S/N 4097 N118GCCole Chevrolet Inc · Pocatello, IDBuilt 2006 · S/N 1912 N118GMUtah State University · Logan, UTBuilt 2005 · S/N 40.521 N118GSOliver Mark Christopher · Greenwood, SCBuilt 2004 · S/N 0884 N118HHN112hh-2 LLC · Whiting, VTBuilt 2016 · S/N 4427 N118JGRopewalk Investments LLC · Wilmington, DEBuilt 1995 · S/N 4622187 N118JVTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2005 · S/N 4697235 N118PGAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2008 · S/N 2905 N118UVUtah Valley University · Orem, UTBuilt 2020 · S/N 40.1224 N118WHWindward Aero LLC · Moultonborough, NHBuilt 2020 · S/N 4914 N1190HBergman William George · Muskegon, MIBuilt 1977 · S/N 28-7716002 N1191HBurford John W Trustee · Madison, MSS/N 28-7790294 N1198ZExecutive Airfleet LLC · Boca Raton, FLS/N 411151 N119ALSch Aviation Inc Trustee · Sporle Kings LynnS/N 3896

Back to AD 2008-06-28 R1