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.

N551MDVero Technical Support Inc · Pensacola, FLBuilt 1978 · S/N 44-7995112 N551PUSkyborne Airline Academy Inc · Vero Beach, FLBuilt 2000 · S/N 2842088 N551SGAviation Module LLC · Los Angeles, CABuilt 2017 · S/N 4562 N551SRN551sr Aviation LLC · Roswell, GABuilt 2006 · S/N 2126 N551TTSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1997 · S/N 3257026 N5520VDouble M Farms LLC · Walsh, COS/N 28-7790479 N5521VAllen Aviation LLC · Leesport, PAS/N 28-7790480 N5525VFlying Particles Inc · Livermore, CAS/N 28-7790481 N552CDDirect Internet Inc · Harsens Islands, MIS/N 0922 N552DLSky West Aviation Inc Trustee · Albuquerque, NMS/N 4410157 N552FSSciortino Frank M · Oswego, NYBuilt 2023 · S/N 9552 N552MDHillsboro Aero Academy LLC · Hillsboro, ORBuilt 1978 · S/N 447995008 N552PCSaint Louis University · Saint Louis, MOBuilt 2001 · S/N 4496069 N552PGElectric Parrot Inc · Healdsburg, CABuilt 2008 · S/N 2007 N552PUSkyborne Airline Academy Inc · Vero Beach, FLBuilt 2000 · S/N 2842089 N552SRGenung Tobin J · Ocala, FLBuilt 2007 · S/N 2278 N553AMUnderwood Chris · Beverly Hills, FLBuilt 1981 · S/N 441-0219 N553CDMhz Management LLC · Wilmington, DEBuilt 2005 · S/N 1638 N553DSKowal Michael T · Colleyville, TXBuilt 2006 · S/N 40.633 N553LBLive Big Air LLC · Athens, GABuilt 2015 · S/N 4242 N553PCSaint Louis University · St Louis, MOBuilt 2001 · S/N 4496072 N553PUSkyborne Airline Academy Inc · Vero Beach, FLBuilt 2000 · S/N 2842090 N553SCSpartan Education LLC · Tulsa, OKBuilt 2020 · S/N 2881342 N553TPOakland Flyers LLC · Oakland, CABuilt 1975 · S/N 28-7690105 N5544MSchar Aviation LLC · Dallas, TXBuilt 2003 · S/N 1335 N554DSFournier Pierre-Marc · Brooklyn, NYBuilt 2006 · S/N 40.634 N554MCWilliams Michael · Fort Wayne, INBuilt 2006 · S/N 2057 N554PUSkyborne Airline Academy Inc · Vero Beach, FLBuilt 2000 · S/N 2842091 N554RRegistered aircraftBuilt 1976 · S/N 28-7690382 N554UTC172 LLC · Rogers, ARBuilt 2022 · S/N 9014 N554ZCaliber Aircraft LLC · Greensboro, NCBuilt 2008 · S/N 411057 N555AUInternational Air Services Inc Trustee · Carson City, NVBuilt 2007 · S/N 4697338 N555AVUpslope Aviation LLC · Boulder, COBuilt 2004 · S/N 0990 N555BPBayusik Kevin R · Shelton, CTBuilt 1980 · S/N 32R-8029072 N555BTPeters Andrew Thomas · Annandale, MNS/N 34-8233014 N555CBEnyedi Alexander Joseph · Plattsburgh, NYBuilt 2011 · S/N 3729 N555FWCommerce Flight LLC · Commerce, TXBuilt 1982 · S/N BB-1055 N555GPPlane Intentions LLC · Lobelville, TNBuilt 2013 · S/N 4697534 N555GQHarbor View Management Services LLC · Henrico, VABuilt 2008 · S/N 1988 N555HAYasko Gary R · Gallipolis, OHBuilt 1978 · S/N 28-7916125 N555HFChristiansen Aviation LLC · Wilmington, DEBuilt 2003 · S/N 4496176 N555JMFingerlakes Area Pilots Inc · Seneca Falls, NYBuilt 1979 · S/N 28-7916412 N555JPMina Mach Partners LLC · Sioux Falls, SDBuilt 2004 · S/N 0970 N555JVColumbia Recreation LLC · Quincy, WABuilt 2000 · S/N 4636270 N555KCBashir Atlantic LLC · Wilmington, DEBuilt 2004 · S/N 1438 N555KPSkyline Aviation LLC · Sheridan, WYBuilt 2025 · S/N 11096 N555MBOpus Partners LLC · Orlando, FLBuilt 2018 · S/N 4636722 N555MNThomas David R · Apex, NCBuilt 2003 · S/N 0664 N555PUSkyborne Airline Academy Inc · Vero Beach, FLBuilt 2000 · S/N 2842092 N555QFColumbia Asset Trust Corp Trustee · Wichita, KSBuilt 1992 · S/N 2890173

Back to AD 2008-06-28 R1