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.

N57DROrellana Werner Jr · Richmond, TXS/N 28-8016035 N57DVDefebo Edward · East Stroudsburg, PABuilt 1968 · S/N 28R-30732 N57FECavu Air LLC · Lees Summit, MOBuilt 2005 · S/N 1521 N57FTS & H Holdings LLC · Wichita, KSS/N BB-136 N57GAKa73 LLC · Little Rock, ARBuilt 1979 · S/N BB-477 N57GBStonehocker Scott · Layton, UTBuilt 1967 · S/N 28R-30240 N57JAN57ja LLC · Quakertown, PABuilt 1979 · S/N 28-7990270 N57JWBoard Of Trustees Of Western Michigan University · Battle Creek, MIBuilt 2006 · S/N 1641 N57MARegent Trust Co Trustee · Wichita, KSBuilt 2022 · S/N 2881556 N57PGShirman Leon · Redwood City, CABuilt 2007 · S/N 2674 N57PUEight Ball Flying Club · Van Nuys, CAFirst renewal noticeBuilt 2002 · S/N 40.214 N57PXHoosier Skies LLC · Indianapolis, INBuilt 2021 · S/N 2738 N57RJD&J Training Planes LLC · Logan, UTBuilt 2016 · S/N 4382 N57RKN57rk LLC · Rockwell, NCBuilt 2004 · S/N 3232016 N57RROdette David N · Thief River Falls, MNBuilt 1968 · S/N 28R-30467 N57RXVolar Ix LLC · Edmond, OKBuilt 2026 · S/N 11295 N57RZSierra Tango Ventures LLC · Monte Sereno, CABuilt 2009 · S/N 3439 N57SAFort Wayne Aircraft LLC · Fort Wayne, INBuilt 2024 · S/N 10093 N57TUKagley Larry D · Greenwood, SCBuilt 2002 · S/N 0377 N57WBBig Red Spring LLC · Fernandina Beach, FLBuilt 1983 · S/N 32R-8329034 N5804FNoonday Sun LLC · Kensington, OHBuilt 1976 · S/N 28-7790134 N5804VNationwide Aviation LLC · Hudson Oaks, TXBuilt 1977 · S/N 28-7716204 N5806VJolliff Herbert H · Independence, ORBuilt 1977 · S/N 28-7716205 N580AGSalaita Michael Dee · Palm City, FLBuilt 2003 · S/N 3246211 N580CDel Aviator LLC · Sea Bright, NJBuilt 2003 · S/N 1293 N580CALongleaf Leasing LLC · Mendenhall, MSBuilt 2025 · S/N 11063 N580GCareer Pilot Training LLC · Wilmington, DEBuilt 2019 · S/N 2881191 N580JAHot Wings Aviation LLC · Indianapolis, INBuilt 2022 · S/N 28020080 N580MMRoriz Joao · Oak Bluffs, MABuilt 2008 · S/N 4692080 N580NDChristiansen Aviation LLC · Wilmington, DEBuilt 2008 · S/N 4496257 N580SRNose Up Speed Aviation LLC · Durango, COBuilt 2007 · S/N 2580 N580UBoard Of Regents Of The University Of Oklahoma · Norman, OKBuilt 2024 · S/N 28020165 N5812VRoark Gidion T Jr · New Roads, LAS/N 28-7790501 N5813VRose William A · Chesapeake, VABuilt 1977 · S/N 28-7790502 N5817FWicker John E · Lexington, NCBuilt 1976 · S/N 28-7790136 N581COn Call Aviation LLC · Brentwood, TNBuilt 2003 · S/N 1271 N581CDLig Air Services LLC · New York, NYBuilt 2022 · S/N 8972 N581GLBarnes Roy Rawlings Jr · Morehead City, NCBuilt 2009 · S/N 411129 N581KAtp Aircraft 3 LLC · Wilmington, DEBuilt 2017 · S/N 2843916 N581MTMiddle Tennessee State University · Murfressboro, TNBuilt 2004 · S/N 40.397 N581NDChristiansen Aviation LLC · Wilmington, DEBuilt 2008 · S/N 4496258 N581RVKurtz Andrew · Boise, IDBuilt 2011 · S/N 4636507 N581SDDakota Cross Winds LLC · Bismarck, NDBuilt 2008 · S/N 3171 N581SGOetting William C · Midland, ORS/N 3257049 N581THCirrus Design Corp · Duluth, MNBuilt 2026 · S/N 11605 N5823AAtp Aircraft 8 LLC · Wilmington, DEBuilt 2008 · S/N 4496260 N5829DCounty Of Henrico Va · Henrico, VABuilt 2018 · S/N 4636739 N582ASChip Henry Aviation LLC · Bel Aire, KSBuilt 1996 · S/N 4636036 N582BLSolera Aviation LLC · Bozeman, MTBuilt 2025 · S/N 2881959 N582CDLix Thomas A · Billings, MTS/N 1584

Back to AD 2008-06-28 R1