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.

N792MARivas Victor · Bayport, NYBuilt 2012 · S/N 4636559 N792NDUnd Aerospace Foundation · Grand Forks, NDBuilt 2017 · S/N 4496407 N792PGWestchester Airplane Rental II LLC · Larchmont, NYBuilt 2009 · S/N 3372 N792PS792ps LLC · Franklin, TNBuilt 2006 · S/N 1872 N792SRBest22 LLC · Phoenix, AZBuilt 2007 · S/N 2792 N792TMWalk On Holdings LLC · Hattiesburg, MSBuilt 2018 · S/N 4721 N7933CLaytham Ricky A · Coatesville, PAS/N 28-7690090 N7938CVolar Corp · El Cajon, CABuilt 1979 · S/N 28-7916428 N793AMeridian Aircraft LLC · Wilmington, DEBuilt 2014 · S/N 2843796 N793CAChristiansen Aviation LLC · Wilmington, DEBuilt 2024 · S/N 2881765 N793CDRbj Tn Holdings LLC · Cleveland, TNS/N 1099 N793KBRyal Holdings LLC · Jamestown, CABuilt 2007 · S/N 2749 N793NDUnd Aerospace Foundation · Grand Forks, NDBuilt 2017 · S/N 4496408 N793USUtah Valley University · Orem, UTS/N 40.793 N7944CAugter Gary K · Mcalester, OKS/N 28-7690091 N794AMeridian Aircraft LLC · Wilmington, DEBuilt 2014 · S/N 2843797 N794BKMaxlines LLC · Fairfax, CABuilt 1979 · S/N 28-7916556 N794LBLb Aviation LLC · Norma, NJBuilt 2024 · S/N 10369 N794NDUnd Aerospace Foundation · Grand Forks, NDBuilt 2018 · S/N 4496434 N7951GJespersen James A · Iowa City, IABuilt 2001 · S/N 1158 N795ABam Diversified Services LLC · Athens, TXBuilt 2014 · S/N 4636618 N795AMBoone Aviation Services LLC · High Point, NCBuilt 2004 · S/N 0997 N795EEHummingbird H2 LLC · Amarillo, TXBuilt 2007 · S/N 2804 N795FApplegarth Investment Co LLC · Kentfield, CABuilt 2007 · S/N 4697316 N795MAAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1995 · S/N 4636007 N795PAPdx LLC · Indianapolis, INS/N BB-328 N7965FLustig Barry J · San Ramon, CABuilt 1976 · S/N 28-7790229 N7967CDeer Park Air Center LLC · Deer Park, WABuilt 1975 · S/N 28-7690094 N7969FWylie Timothy M · Santa Cruz, CAS/N 28-7790230 N796JDTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2008 · S/N 4697372 N796NDUnd Aerospace Foundation · Grand Forks, NDBuilt 2018 · S/N 4496435 N796PGSaco Leasing LLC · Dunwoody, GABuilt 2008 · S/N 3348 N7972CJust Plane People LLC · Irvine, CABuilt 1975 · S/N 28-7690095 N797AMBarren Aviation LLC · Glasgow, KYBuilt 2006 · S/N 40.717 N797BTCollins Jeffery Scott · Fort Myers, FLBuilt 2002 · S/N 0340 N797CDPhronesis LLC · Tucson, AZBuilt 2006 · S/N 1897 N797MAJtcc Products LLC · Fairview Park, OHBuilt 1997 · S/N 4636108 N797MCTim 2 Fly LLC · Conroe, TXBuilt 1997 · S/N 4636117 N797NDUniversity Of North Dakota · Grand Forks, NDS/N 4496504 N797RSGinier Bruce L · Fresno, CABuilt 2009 · S/N 40.1029 N797RWFlying Sadie LLC · Palm Beach Gardens, FLS/N 441-0185 N797SLow Wing 797 LLC · Aurora, ILBuilt 1997 · S/N 3257003 N797SMLowry Michael R · Los Altos Hills, CABuilt 2003 · S/N 0616 N797SRAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2007 · S/N 2770 N797TN797t Aviation LLC · Stanfield, NCBuilt 2003 · S/N 42031 N797TFTurrisi Flight Training LLC · Hilton Head, SCBuilt 2014 · S/N 2250 N797TLTerra Luna Transportation Inc · West Palm Beach, FLBuilt 2003 · S/N 1329 N798BBFlyboys LLC · Mobile, ALBuilt 2005 · S/N 1435 N798DSWindemere Group LLC · Redwood City, CABuilt 2007 · S/N 40.798 N798NDYale Companies LLC · Fishers, INBuilt 2018 · S/N 4496436

Back to AD 2008-06-28 R1