OpenAirDocs.org
AD 2008-06-28 R1

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
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.

N224MVAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2006 · S/N 1922N224NDGood Flight Aviation LLC · Stockton, CABuilt 2001 · S/N 2842112N224NHLola Leasing LLC · Sugar Land, TXBuilt 2009 · S/N 3569N224NXNexair Avionics LLC · Plymouth, MABuilt 2002 · S/N 0170N224PBDeaux James · Collierville, TNBuilt 2006 · S/N 1754N224PCCarlson Craig B Trustee · Los Altos, CABuilt 2018 · S/N 4655N224PFKurrle Ryan J · Austin, TXBuilt 2006 · S/N 1917N224PJLeng Jason W · Chehalis, WABuilt 2006 · S/N 2281N224RCSky West Aviation Inc Trustee · Albuquerque, NMS/N 2919N224RFWby Inc · Orange, CABuilt 2002 · S/N 1178N224RJDuke Mfg Of Florida LLC · Saint Louis, MOBuilt 2013 · S/N 4027N224RTIronwood Aviation LLC · Boerne, TXBuilt 2008 · S/N 3268N224RWNomad Air LLC · North Bend, WABuilt 2005 · S/N 1595N224SJPrestige Aircraft LLC · Madison, WIBuilt 2003 · S/N 0705N224SRRaffo Christopher Stephen · Potomac, MDBuilt 2006 · S/N 2172N224STB & G Aviation Enterprises LLC · Lilburn, GABuilt 2004 · S/N 0882N224SYMrc1 LLC · Bernie, MOBuilt 2002 · S/N 0184N224TBHot Wings Aviation LLC · Indianapolis, INBuilt 2023 · S/N 28020126N224TGPlaneview LLC · Fountain Hills, AZBuilt 2005 · S/N 1570N224UQue Estaran Haciendo LLC · North Miami, FLBuilt 2008 · S/N 3129N224VUp And Up Aviation LLC · Magnolia, TXS/N 28-7916402N224VWMeridian Aircraft LLC · Wilmington, DEBuilt 2022 · S/N 2881533N224WMSchock Steven W · Huntington Beach, CAS/N 40.538N224WTSkizer Inc · Marina Del Rey, CABuilt 2006 · S/N 1947N224YBFly Robin Fly LLC · Marietta, GABuilt 2025 · S/N 11048N2250BBill Frank J · Enfield, CTBuilt 1978 · S/N 28-7916122N2250KKaemmerling Mirna C · White Oak, TXBuilt 1978 · S/N 28-7990240N225CBCalifornia Baptist University · Riverside, CABuilt 2023 · S/N 2881634N225CDCirrus Design Corp · Duluth, MNS/N 11631N225FSmall Inc · Senath, MOBuilt 2016 · S/N 4330N225FDHoldings Excellence LLC · Frostproof, FLBuilt 2023 · S/N 9167N225FGMeridian Aircraft LLC · Wilmington, DEBuilt 2022 · S/N 2881569N225KLMeridian Aircraft LLC · Wilmington, DEBuilt 2022 · S/N 2881534N225KWZia Air LLC · Hagerman, NMBuilt 2006 · S/N 41671N225MAAerial Services Inc · Cedar Falls, IABuilt 2001 · S/N 4697106N225MCP46 Tango LLC · Friday Harbor, WABuilt 1999 · S/N 4636239N225PETspy Services Inc · Wilmington, DES/N 4286N225RLReeves Kyle · Newport Beach, CAS/N 2981N225RPSkt Aviation LLC · Madison, MSBuilt 2023 · S/N 9246N225RSMeridian Aircraft LLC · Wilmington, DEBuilt 2022 · S/N 2881543N225SDCirrus Design Corp · Duluth, MNS/N 11672N225TBHot Wings Aviation LLC · Indianapolis, INBuilt 2023 · S/N 28020127N225TLChute Happens LLC · Annandale, VABuilt 2017 · S/N 4478N225TNA C Leonard LLC · Missoula, MTBuilt 2008 · S/N 3108N225VTSls Travel LLC · Missoula, MTBuilt 2017 · S/N 4448N225YZYankee Zulu LLC · New York, NYBuilt 2015 · S/N 2291N2260MBomar Robert B · Bedford, TXBuilt 1977 · S/N 28-7816264N2261QAndrews University · Berrien Springs, MIBuilt 1977 · S/N 28-7790386N2262FAnchor Aviation LLC · Blue Bell, PABuilt 1978 · S/N 28-7990074N2262MAg Air Squadron Two LLC · Saint Joseph, ILBuilt 1977 · S/N 28-7816265
Back to AD 2008-06-28 R1