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.

N5319AN5319a Corp Trustee · Wilmington, DES/N 2843435N5319JSouthwinds Export Inc · Kissimmee, FLS/N 3257213N5319KEyedollar LLC · Denton, TXS/N 4697076N5319MPaphos Airways LLC · Farmingdale, NYS/N 2842122N5319XMeadowlake Aviation LLC · Lenoir City, TNS/N 2842119N531AMcs Aviation LLC · Wetumpka, ALBuilt 2000 · S/N 32-57160N531BMJ&V Sky LLC · West Covina, CABuilt 1979 · S/N 28-7990510N531CCN Wilson Holdings LLC · Plattsburgh, NYBuilt 2010 · S/N 3681N531CDSasha Rose Express LLC · Scottsdale, AZBuilt 2005 · S/N 1622N531HBAdk Realty LLC · Chadds Ford, PABuilt 2005 · S/N 1579N531MGN422pj LLC · Missoula, MTBuilt 1999 · S/N 2843260N531NABlue Skies Leasing Inc · Port Orange, FLBuilt 1977 · S/N 28-7790414N531PTViking Aviation LLC · Catoosa, OKS/N 3257280N531RFNovember Tango LLC · Richmond, VABuilt 2006 · S/N 40.631N531SDBailey Air LLC · Delhi, LABuilt 2006 · S/N 1906N531SFNj 70 Aviation LLC · Weston, FLBuilt 2024 · S/N 10079N531SR1940 Cdg LLC · Aledo, TXBuilt 2007 · S/N 2438N531TRCirrus Design Corp · Duluth, MNBuilt 2026 · S/N 11112N5320NSaunders Aviation LLC · Lewes, DEBuilt 2003 · S/N 4697153N53216Alf Ix LLC · Chicago, ILS/N 2843445N5321RTexas State Technical College · Waco, TXFirst renewal noticeS/N 4496045N53220Sidekick Aviation LLC · Tuscaloosa, ALBuilt 2004 · S/N 0865N53229Boos Michael R · Brandenburg, KYBuilt 2001 · S/N 3246188N5322AD & J Aviation LLC · Apopka, FLS/N 4496081N5322DBlack Phoenix Photography LLC · Morgan Hill, CABuilt 2001 · S/N 4697074N5322JResearch Insight LLC · Laguna Beach, CABuilt 2001 · S/N 2843441N5322KScare Air LLC · Saint Augustine, FLS/N 3257243N5322MFlight Club LLC · Erie, PABuilt 2000 · S/N 4697021N5322XRodriguez Robert H · Alpine, CABuilt 2001 · S/N 2843483N53235Aerospace Trust Management LLC Trustee · Wilmington, DES/N 4697083N5323FSilmi Amjad · Oakland, CABuilt 1976 · S/N 28-7790087N5323XGlobal Aviation Corp · Farmingdale, NYBuilt 2013 · S/N 2842392N5324CAri Ben Aviator Inc · Fort Pierce, FLS/N 2843449N5324PN5324p LLC · Naples, FLBuilt 2001 · S/N 2843452N53259Donatelle Michael J · North Oaks, MNS/N 3257248N5325PJpr Investments LLC #51 · Fargo, NDS/N 4697085N53264Van De Wall Allan · Oro Valley, AZBuilt 2001 · S/N 3257220N53266Jazzair LLC · Erie, COBuilt 2001 · S/N 3257233N5326RHigher Milam Aviation LLC · Columbia, MOBuilt 2001 · S/N 3246196N5327MStine Enterprises LLC · Plant City, FLS/N 3246192N5328ESouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 2001 · S/N 3257256N5328LUniversity Of Illinois · Savoy, ILBuilt 2001 · S/N 4496108N53297Sky West Aviation Inc Trustee · Albuquerque, NMBuilt 2004 · S/N 0898N5329F29foxtrot LLC · Wilmington, DES/N 4636316N5329QMitzel Eddy Jacob · Mandan, NDS/N 4697097N532CACulebra Aviation & Services LLC · San Juan, PRBuilt 1989 · S/N 2841282N532DREllebracht Steve · Sedalia, MOBuilt 1998 · S/N 3257060N532JTSowards David · Savannah, GABuilt 2004 · S/N 0834N532MJJama Leasing LLC · Fort Myers, FLS/N 3246203N532PGJdh Aviation LLC · Centerton, ARBuilt 2008 · S/N 1991
Back to AD 2008-06-28 R1