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.

N804CSalcedo Eduardo · San Diego, CABuilt 2013 · S/N 4636602 N804CLDickerson Richard S · Powhatan, VABuilt 2016 · S/N 4360 N804DBWaterside Aviation LLC · San Jose, CABuilt 2008 · S/N 3212 N804ERDiamond Aircraft Sales Of Kentucky LLC · Henderson, KYBuilt 2003 · S/N 40.311 N804JHRocky Mountain Boat Co · Pueblo West, COBuilt 2001 · S/N 4697044 N804LMMti Leasing LLC · Atlanta, GABuilt 2007 · S/N 41718 N804LXBeepfly Inc · Los Angeles, CABuilt 2009 · S/N 3488 N804SGKtw Aviation LLC · Scottsdale, AZBuilt 2020 · S/N 2570 N804TSHelice Sarcelle LLC · Fair Oaks Ranch, TXBuilt 2022 · S/N 8873 N8051VAv8 Flight Assets LLC · Eden Prairie, MNBuilt 2021 · S/N 2881106 N8052AChristiansen Aviation LLC · Wilmington, DEBuilt 2019 · S/N 4496461 N8052TAtd Pilot Training LLC · Kansas City, MOBuilt 1981 · S/N 28-8216091 N8054SMccrea Stephen M · Eatonton, GABuilt 1981 · S/N 28-8290077 N8055CSea 2 Sea LLC · Cantonment, FLS/N 28-7690099 N8055VSandler Sergey · Golden Beach, FLBuilt 1981 · S/N 288290078 N8059RTravel Express Aviation LLC · West Chicago, ILBuilt 1981 · S/N 28-8290081 N805AMOrtega Aviation Services LLC · Wichita, KSBuilt 2021 · S/N 28020036 N805ATFlight School Of Texas LLC · Wilmington, DEBuilt 2013 · S/N 4496334 N805LLAerojet USA LLC · Knox, INBuilt 2003 · S/N 0741 N805MAKpanda Aviation LLC · Peoria, ILBuilt 2022 · S/N 2881585 N805MXKinsale Associates LLC · Everett, WABuilt 2006 · S/N 2237 N805SERc Electronics Inc · Helena, MTBuilt 2002 · S/N 0430 N805SRDelta Delta Papa LLC · Fort Lauderdale, FLBuilt 2006 · S/N 1998 N805WSky 805 LLC · Camarillo, CABuilt 2023 · S/N 9302 N8060USluka Christopher J · San Diego, CABuilt 1981 · S/N 28-8290083 N8061VCheairs William T · Covington, TNBuilt 2003 · S/N 0649 N8062TDitullio Peter C · Fallbrook, CABuilt 1981 · S/N 32R-8229027 N8063CHigh Planes Aviation LLC · Goodland, KSBuilt 1975 · S/N 28-7690100 N8064XDodson International Parts Inc · Rantoul, KSBuilt 2022 · S/N 2881516 N8068CThunderbird Aircraft Company · Bloomington, MNBuilt 1981 · S/N 28-8216099 N8068JGo Vertical Aviation LLC · Russellville, ALBuilt 1981 · S/N 28-8290084 N8068ZBasco John J · Pottstown, PABuilt 1981 · S/N 28-8290086 N8069AInfinity Aviation St Cloud LLC · Rice, MNBuilt 1981 · S/N 32R-8213027 N8069SGates Joel L · Salida, COBuilt 1981 · S/N 32R-8229028 N806ATFlight School Of Texas LLC · Wilmington, DEBuilt 2013 · S/N 4496335 N806BMAlbatross Aviation LLC · Ponte Vedra Beach, FLBuilt 2015 · S/N 4186 N806BPLone Mountain Aircraft Training LLC · Vandalia, OHBuilt 2019 · S/N 2524 N806CDLewis Melvin Lee Jr · Fisk, MOBuilt 2001 · S/N 0106 N806DMOcf Air LLC · Phoenix, AZBuilt 2013 · S/N 2228 N806ECFlynn Development Corp · Clearwater, FLBuilt 2004 · S/N 0839 N806ERDiamond Aircraft Sales Of Kentucy LLC · Henderson, KYBuilt 2003 · S/N 40.317 N806TBInhoc Aviation LLC · Dallas, TXBuilt 2020 · S/N 2644 N80702Over The Numbers LLC · Churchville, PABuilt 1981 · S/N 32R-8229030 N8070RRegistration Pending · Austin, TXRegistration pendingS/N 32R-8229029 N8071SNolan Cynthia M · Rimrock, AZBuilt 1981 · S/N 28-8216102 N8071XFlorida Aviation Career Training Inc · Saint Augustine, FLS/N 28-8216103 N8071YFrost Aviation Services Inc · Las Cruces, NMBuilt 1981 · S/N 28-8216104 N8071ZScanlon Daniel T Jr · East Greenwich, RIBuilt 1981 · S/N 28-8290087 N80731Herman Robert W · Vineyard Haven, MABuilt 1981 · S/N 28-8290089 N80746Gregor Ruslan · West Hartford, CTBuilt 2003 · S/N 1364

Back to AD 2008-06-28 R1