Registered aircraft · 16,284

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.

N995FGFlightgest Academy LLC · Morrisville, NCBuilt 2025 · S/N 2881883 N995KTHorizon 1p1 Capital Holdings LLC · Oneill, NEBuilt 2014 · S/N 4636640 N995SPmg-Sr22t LLC · Greenville, NCBuilt 2003 · S/N 4697154 N995TBTravel Lecture Learn LLC · Sicklerville, NJBuilt 2016 · S/N 4430 N995TTQuick Air LLC · Mandeville, LAS/N 3823 N995WBTrue North Aviation LLC · Harrisburg, SDBuilt 2017 · S/N 4556 N995WDTactical Capital LLC · Hudson, OHS/N 4908 N9962Valiair Lc Trustee · Casper, WYBuilt 2008 · S/N 1914 N9966GN513pk Holdings LLC · Haverhill, MABuilt 2005 · S/N 3257370 N996CKb Family LLC · Santa Clara, UTBuilt 2021 · S/N 4636794 N996CDGrace Flying Service Inc · Saint Francis, KSBuilt 2005 · S/N 1499 N996EPLehecka Richard T · Spring Grove, ILBuilt 2015 · S/N 4636658 N996FGFlightgest Academy LLC · Morrisville, NCBuilt 2022 · S/N 2881598 N996PAPalomar Aviation LLC · Carlsbad, CABuilt 2024 · S/N 9966 N996WCirrus Design Corp · Duluth, MNS/N 11724 N997CDN997cd Corp Trustee · Wilmington, DEBuilt 2004 · S/N 0893 N997CWDanesy Dorothea H · Pasadena, CABuilt 1977 · S/N 28-7716049 N997FGFlightgest Academy LLC · Morrisville, NCBuilt 2025 · S/N 2881954 N997JKEastern Stearman Inc Trustee · Leesburg, VABuilt 2005 · S/N 41108 N997LMLowcountry Aviation Company Brokerage LLC · Walterboro, SCBuilt 1976 · S/N BB217 N997MADodson International Parts Inc · Rantoul, KSBuilt 1997 · S/N 4636126 N997MJNeal Daniel R · Tijeras, NMBuilt 1999 · S/N 4636228 N997MMDavis Transportation Services LLC · Cokeville, WYBuilt 2006 · S/N 41705 N997PSFuel X LLC · Pearl, MSBuilt 2024 · S/N 10178 N997SGRas Aviation LLC · Elyria, OHBuilt 1978 · S/N 28-7816562 N997TDAscent Aviation Inc · Duluth, MNBuilt 2016 · S/N 2328 N997UWAscent Aviation Inc · Duluth, MNBuilt 2016 · S/N 2327 N997WPCirrus Design Corp · Duluth, MNBuilt 2026 · S/N 11553 N9984GIndura Air Holdings LLC · Bloomfield Hills, MIBuilt 2016 · S/N 4345 N9989Bank Of Utah Trustee · Salt Lake City, UTBuilt 2025 · S/N 11060 N998CDLindsay Allan · Papillion, NEBuilt 2003 · S/N 0482 N998CTCti Aircraft Leasing LLC · Memphis, TNS/N 2881297 N998EKAopa Foundation Inc · Frederick, MDBuilt 2016 · S/N 4353 N998FGFlightgest Academy LLC · Morrisville, NCBuilt 2025 · S/N 2881960 N998JWBowtie Investments LLC · Schriever, LAS/N 2989 N998LLN998limalima LLC · Miramar, FLBuilt 2018 · S/N 2425 N998MAWarhawk LLC · Latrobe, PABuilt 1998 · S/N 3246105 N998RCCf Holdings LLC · Hernando, MSBuilt 2018 · S/N 4727 N998WTMkeair LLC · Waukesha, WIBuilt 2002 · S/N 0210 N9991Sale Reported · Kalispell, MTSale reported, canceledBuilt 2001 · S/N 0079 N999ABBentrup Reinhard · Goleta, CABuilt 1979 · S/N 32R-8029043 N999ANOsi Air LLC · Wilmington, DEBuilt 2005 · S/N 1668 N999BYBrace Yourself Orthodontics Inc · Portsmouth, OHBuilt 2007 · S/N 2858 N999DTX Stallion Ventures LLC · Jacksonville, TXBuilt 1976 · S/N BB-138 N999DXJourneyman Aviation LLC · Louisville, KYBuilt 2003 · S/N 0582 N999ETJet Aero LLC · Montoursville, PABuilt 2003 · S/N 0476 N999GEWright Way Trailers Inc · Toddville, IABuilt 2000 · S/N 1057 N999GLGarmin International · Olathe, KSBuilt 2004 · S/N 41034 N999HSBurton John R · Punta Gorda, FLBuilt 1968 · S/N 28R-30716 N999KDKretschmer Fred L Jr · Vero Beach, FLS/N 28-7790181

Back to AD 2008-06-28 R1