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.

N630RCLee Aviation Services Co LLC · Pensacola, FLBuilt 2015 · S/N 4228 N630RJHovan Robert G · Port Orange, FLBuilt 1979 · S/N 28-7916503 N630SFAll American Aviation Services Inc · Fayetteville, NCBuilt 2007 · S/N 1812 N630TGTriple Diamond Group LLC · Boerne, TXBuilt 2008 · S/N 4692079 N6312CLibra Air Inc · Las Vegas, NVBuilt 1978 · S/N 28-7816405 N6313CShouling & Philip Enterprise · Lancaster, CABuilt 1978 · S/N 28-7816406 N6319CNew York Aviators LLC · South Ozone Park, NYBuilt 1978 · S/N 28-7890362 N631AVWestwind School Of Aeronautics Phoenix LLC DBA · Goodyear, AZBuilt 2025 · S/N 10933 N631BRBrady Risk Holdings LLC · Farmingdale, NYBuilt 2022 · S/N 8513 N631FTFlorida Institute Of Technology · Melbourne, FLBuilt 1981 · S/N 28-8216036 N631NDUniversity Of North Dakota · Grand Forks, NDBuilt 2019 · S/N 2881166 N631PCPiper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 28020282 N631RJBusiness Flyers LLC · Bedford, MAS/N 3425 N631SRBranch Leasing LLC · Paris, TNBuilt 2007 · S/N 2442 N632BZRegistration Pending · Liberty, NCRegistration pendingBuilt 2026 · S/N 4496632 N632CDBirch Run Aviation LLC · Wayne, PAS/N 1641 N632HGValiair Limited Co Trustee · Casper, WYBuilt 2026 · S/N 11632 N632NDUniversity Of North Dakota · Grand Forks, NDBuilt 2019 · S/N 2881153 N632PMCentral Valley Air Transportation LLC · Fresno, CABuilt 2014 · S/N 4636632 N632SCSpartan Education LLC · Tulsa, OKBuilt 2021 · S/N 2881433 N632UBWeigand James F · Auburn, MEBuilt 2008 · S/N 3299 N6331CLambert James Donald · Sterling, COBuilt 1978 · S/N 28-7816408 N6334CPrescott Flying Club Inc · South Saint Paul, MNBuilt 1978 · S/N 28-7816409 N633AVWestwind School Of Aeronautics Phoenix LLC DBA · Goodyear, AZBuilt 2025 · S/N 10949 N633BLdba LLC · Las Vegas, NVS/N 3103 N633CDPolaris Fire Protection Inc · Port Charlotte, FLBuilt 2002 · S/N 0369 N633DCRitchie Holdings LLC · Yorktown, VABuilt 2008 · S/N 40.940 N633DSIn Flight Aircraft LLC · Howell, MIBuilt 2006 · S/N 40.613 N633GEFly High LLC · Seminole, TXS/N 1487 N633SRTippman & Dumas Aviation LLC · Fort Wayne, INBuilt 2006 · S/N 2014 N633TAChristiansen Aviation LLC · Wilmington, DEBuilt 2001 · S/N 4496052 N6341CD & D Design & Manufacturing Inc · Wheatland, OKBuilt 1978 · S/N 28-7816411 N6344CPayne Ernest Charles · Dana Point, CABuilt 1978 · S/N 28-7890364 N634GRMurfs Aircraft Sales LLC · Fort Myers, FLBuilt 1996 · S/N 3447023 N634KCapital Air Service LLC · Tallahassee, FLBuilt 2007 · S/N 41735 N634SFRhodenbaugh John T Trustee · Cincinnati, OHBuilt 2007 · S/N 1827 N634STDc Skies LLC · Pasadena, CABuilt 2018 · S/N 4697634 N634WSun South Of Jennings LLC · Jennings, LABuilt 2002 · S/N 0164 N634WMBoard Of Trustees Of Western Michigan University · Kalamazoo, MIBuilt 2024 · S/N 9841 N6358CWoodhams Real Estate Group LLC · Atlanta, GABuilt 1978 · S/N 28-7816412 N63593Rbr Development LLC · West Plains, MOBuilt 1979 · S/N BB552 N6359CRas Aviation LLC · Elyria, OHBuilt 1978 · S/N 28-7816413 N635ATTdjb LLC · Tamarac, FLBuilt 2005 · S/N 40.578 N635DSPonici Adrian · East Hanover, NJBuilt 2006 · S/N 40.615 N635FTFlorida Institute Of Technology · Melbourne, FLBuilt 2008 · S/N 2842311 N635KCCavorite Aviation LLC · West Jordan, UTBuilt 2006 · S/N 2843635 N635SCSpartan Education LLC · Tulsa, OKBuilt 2021 · S/N 2881434 N6365CWingsleasing LLC · Wichita, KSBuilt 1978 · S/N 28-7890366 N636ATJr Aircraft Services LLC · Oxford, MIBuilt 2005 · S/N 40.588 N636CPurcell Dave M · Bowling Green, KYBuilt 2002 · S/N 0406

Back to AD 2008-06-28 R1