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.

N4937FRegistered aircraftBuilt 1976 · S/N 28-7790075N493AVWestwind School Of Aeronautics Phoenix LLC DBA · Goodyear, AZBuilt 2023 · S/N 9367N493CDCocozzoli Kevin A · Crestview, FLBuilt 2005 · S/N 1603N493DSDelaware State University · Dover, DEBuilt 1983 · S/N 28-8416011N493MAGreat Planes Aviation Inc · Rochester, MNBuilt 2001 · S/N 2843486N493MSHingley Daniel · Boise, IDBuilt 2007 · S/N 2450N4940UBoard Of Regents Of The University Of Oklahoma · Norman, OKBuilt 2005 · S/N 2842228N4945JAsher Academy · Cameron, TXS/N 28R-30692N4947JElite Fleet LLC · Spofford, NHBuilt 1968 · S/N 28R-30694N4949SSchwenk Holdings LLC · Fort Myers, FLBuilt 2011 · S/N 3796N494AVWestwind School Of Aeronautics Phoenix LLC DBA · Goodyear, AZBuilt 2023 · S/N 9375N494DAAerosim Academy Inc · Sanford, FLBuilt 2007 · S/N 1840N494DSBeulah Ltd Trustee · Wilmington, DEBuilt 2003 · S/N 40.294N494LAPiper 3 LLC · Chestnut Ridge, NYBuilt 2021 · S/N 28020022N494MBMulhearn Walter F · Conroe, TXBuilt 1980 · S/N 32R-8029056N494SRSolaero LLC · Toledo, OHBuilt 2006 · S/N 2263N4953JLent Kevin C · Glenwood, MNBuilt 1968 · S/N 28R-30699N4958FJuoni Joshua Charles · Oklahoma City, OKBuilt 1976 · S/N 28-7790078N4958JWinfrey Justin R · San Francisco, CAS/N 28R-30706N4959JTaylor James O · Marengo, ILS/N 28R-30708N495CCM2 Aero LLC · Powell, OHBuilt 2006 · S/N 2011N495CDJl Aviation LLC · Crestwood, KYBuilt 2005 · S/N 1605N495LAPiper 3 LLC · Chestnut Ridge, NYBuilt 2021 · S/N 28020023N495MAZero G Aviation LLC · Helena, MTBuilt 2010 · S/N 4636484N495PGEurosource LLC · Ames, IAS/N 1954N495PMDmfs Leasing LLC · Des Moines, IABuilt 2025 · S/N 4636871N495RDCapital Holdings 226 LLC · Naples, FLBuilt 2003 · S/N 42032N495SCOptimum Aviation LLC · Sterling, VABuilt 2025 · S/N 10484N495WFWalters Steven M · Marathon, FLBuilt 1995 · S/N 3213097N4961JJones Charles W · La Follette, TNBuilt 1968 · S/N 28R-30710N4962JHuffman Jacob M III · Burleson, TXBuilt 1968 · S/N 28R-30711N4964JShteyn Vladlmir · Huntingdon Valley, PABuilt 1968 · S/N 28R-30714N4967JB F D Inc · Newington, CTBuilt 1968 · S/N 28R-30718N4968JOperation Stinky Weasel LLC · South Lyon, MIBuilt 1968 · S/N 28R-30719N496AVWestwind School Of Aeronautics Phoenix LLC DBA · Goodyear, AZBuilt 2023 · S/N 9409N496CDCirrus Skies LLC · Clayton, MOBuilt 2005 · S/N 1612N496CJPurview LLC · Brownsburg, INBuilt 2025 · S/N 10918N496CPSportmed Outreach Air LLC · Gulf Breeze, FLBuilt 2008 · S/N 3314N496DAAerosim Academy Inc · Sanford, FLBuilt 2007 · S/N 1842N496DSDelaware State University · Dover, DEBuilt 1993 · S/N 2816105N496GRRegistered aircraftBuilt 2019 · S/N 4779N496KGLimited Interest Aviation LLC · Scottsdale, AZBuilt 2010 · S/N 2066N496LAPiper 3 LLC · Chestnut Ridge, NYBuilt 2022 · S/N 28020074N496MAEzboost LLC · Torrance, CABuilt 2005 · S/N 40.496N4971Osborne Scott M · Fort Myers, FLBuilt 2015 · S/N 4174N4971JCreasy Frank Edward III · Suffolk, VABuilt 1968 · S/N 28R-30722N4973JTroftgruben Gregory G · Buxton, NDS/N 28R-30724N4975JP&N Corp · Marion, IABuilt 1968 · S/N 28R-30727N4977JJad Corp · Saint Cloud, MNBuilt 1968 · S/N 28R-30730N4979FEdward Jones Risk Placement Corp · Voorhees, NJS/N 28-7790081
Back to AD 2008-06-28 R1