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.

N421CDTarsky Project LLC · Panama City Beach, FLBuilt 2006 · S/N 1791 N421MJLevine Jonathan L · Waterford, CTBuilt 2000 · S/N 2843338 N422AKAlpha Kilo One LLC · Humble, TXBuilt 2014 · S/N 4099 N422BSN422bs LLC · Bluffton, SCBuilt 2016 · S/N 4362 N422CDMachedge Flight Sim Training LLC · Pell City, ALBuilt 1981 · S/N 28-8190272 N422CWCentral Washington University · Ellensburg, WABuilt 2018 · S/N 4496438 N422DRQualitair LLC · MichelstadtBuilt 2007 · S/N 2705 N422EJAdams A David · Tallahassee, FLBuilt 1979 · S/N 28-7990585 N422GBJacobs Jonathan A · Severna Park, MDBuilt 1999 · S/N 3246143 N422GH422gh Aviation LLC · Tampa, FLBuilt 2008 · S/N 3177 N422GKKierspe Leasing LLC · Aiken, SCBuilt 2025 · S/N 10996 N422JMVertical Consulting LLC · Boise, IDBuilt 2010 · S/N 3656 N422LBMckeever Gregory Allen · Holly Springs, NCFirst renewal noticeBuilt 1981 · S/N 32R-8113030 N422LDMld Services LLC · Atlantic Beach, FLBuilt 2006 · S/N 2154 N422LMJafari Dadbeh · Edmond, OKBuilt 2001 · S/N 0118 N422LTSr Flyers LLC · Baltimore, MDBuilt 2003 · S/N 0730 N422MAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2003 · S/N 1354 N422PRicmar Aviation LLC · Lewes, DEBuilt 2007 · S/N 3232065 N422PCSalty Pines LLC · Haverford, PABuilt 2024 · S/N 10318 N422RJTopflight Aviation Inc · Brentwood, TNBuilt 2013 · S/N 3942 N422RMMoore Aviation Inc · Beaver Falls, PAS/N 2843526 N422SCAg Air Squadron One LLC · Saint Joseph, ILBuilt 1967 · S/N 28R-30022 N422SMCollum Aviation LLC · Milton, FLS/N 28-8116127 N422SNFalcon Flight LLC · Las Vegas, NVS/N 3508 N422SRReno Flight Club LLC · Reno, NVBuilt 2006 · S/N 1976 N422TBMark 2 Aviation LLC · Sand Springs, OKBuilt 2006 · S/N 1888 N422TJ422ktjde LLC · Lewes, DEBuilt 2008 · S/N 411053 N422USParagon Airplane Leasing Co · Fort Myers, FLBuilt 2023 · S/N 28020125 N422WGWilliams Sara J · Kendallville, INBuilt 1980 · S/N 28-8016341 N423ABAms Emergency Services LLC · Phoenix, AZBuilt 2009 · S/N 40.1042 N423BDConcorde Transportation LLC · Freehold, NJBuilt 2020 · S/N 4893 N423BMSouth Regional Aviation Enterprise Inc · Boynton Beach, FLS/N 3255022 N423CDGrzebik Ellerine P · Petaluma, CAS/N 1109 N423CPAltus Aviation LLC · Pike Road, ALBuilt 2013 · S/N 3944 N423CWCentral Washington University · Ellensburg, WABuilt 2018 · S/N 4496439 N423ESCirrus Design Corp · Duluth, MNS/N 11764 N423GSCirrus Design Corp · Duluth, MNS/N 11765 N423JTSoutheast Air Tran LLC · Hahira, GABuilt 1994 · S/N 4622162 N423PABird Acquisition LLC · Phoenix, AZBuilt 2001 · S/N 2843463 N423RElint Technology Inc · Gulf Breeze, FLBuilt 1981 · S/N 32R-8213023 N423RMWrench & Yoke Aviation LLC · Seminole, FLS/N 2843527 N423SV & L Enterprises LLC · Wilmington, DEBuilt 1981 · S/N 34-8233071 N423SRHaloroc Muppets II LLC · Nashville, TNBuilt 2007 · S/N 2459 N424ATInspiring Strength Inc · Redding, CABuilt 2011 · S/N 3817 N424AXPolyloom Corporation Of America Inc · Florence, ALBuilt 2016 · S/N 4308 N424BBYoung Robert N · Stratham, NHBuilt 2015 · S/N 4195 N424BDBadass Aviation LLC · Fernandina, FLBuilt 2005 · S/N 1723 N424CDAirfleet Solutions LLC · Newark, DEBuilt 2004 · S/N 1439 N424CKCca Aviation LLC · Great Bend, KSS/N 3495 N424EGS&R Flying LLC · Franklin, TNBuilt 2004 · S/N 0887

Back to AD 2008-06-28 R1