Registered aircraft · 16,295

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.

N130RGSummit Consultants Inc · Hudson Oaks, TXBuilt 2016 · S/N 4432 N130RLOscar Charlie II LLC · California, MDBuilt 1980 · S/N BT16 N130RRAllbritten Jeffrey P · Winder, GAS/N 2841264 N130URegistered aircraftFirst renewal noticeBuilt 2018 · S/N 4697644 N13106Diamond J Aviation LLC · Greensboro, NCBuilt 2008 · S/N 411106 N1310KVector Aviation LLC · Mentor, OHBuilt 1976 · S/N 28-7790216 N1310MN1310m LLC · Palmyra, VABuilt 2006 · S/N 41678 N1310UPiper Aircraft Inc · Vero Beach, FLBuilt 2025 · S/N 28020247 N1314CDajczak Stanislaw P · Findlay, OHBuilt 2003 · S/N 0502 N1317HLightfoot Carl · Beaumont, TXS/N 28-7790304 N131AGWings Over Texas Holdings LLC · Denton, TXBuilt 2024 · S/N 4496589 N131AMAmis Benjamin · Austin, TXBuilt 2007 · S/N 2865 N131CACoast Flight Training And Management Inc · San Diego, CABuilt 2020 · S/N 2881353 N131CDSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 2000 · S/N 1031 N131EAEagle X LLC · Chamblee, GABuilt 2006 · S/N 2239 N131EGEdgo Flying Inc · Naperville, ILBuilt 2002 · S/N 1248 N131KMKeriair LLC · Point Pleasant, NJBuilt 2025 · S/N 10657 N131LLAims Community College · Greeley, COBuilt 2020 · S/N 2881345 N131MGHarrison Simon M · Libertyville, ILBuilt 2007 · S/N 2830 N131MWFarina George · Killen, ALBuilt 2004 · S/N 41021 N131PAAmeriflyers Of Texas Inc · Addison, TXBuilt 2022 · S/N 28020055 N131RLLeads Air Inc · Dover, DEBuilt 1989 · S/N 4622048 N131SJGravitas Aviation LLC · Dallas, TXBuilt 1976 · S/N BB-131 N131SRValiair Limited Company Trustee · Casper, WYBuilt 2006 · S/N 1887 N131TPremiere Aircraft LLC · Dover, DEBuilt 2009 · S/N 4692103 N131TJPryor Mountain Aviation LLC · Cody, WYBuilt 2009 · S/N 3449 N131VATvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2025 · S/N 10577 N1321CClark Charles G · Catlettsburg, KYBuilt 2006 · S/N 42517 N1322LPfendt Anton N · Spring, TXBuilt 2001 · S/N 0022 N1324QTechnoflight LLC · Verona, WIBuilt 2006 · S/N 41686 N1327GRk Air LLC · Shreve, OHBuilt 2006 · S/N 41689 N132AGMarsh Equipment LLC · Aurora, ORBuilt 2024 · S/N 4496590 N132AMTemple James C · Lincoln, CABuilt 1978 · S/N 28-7990245 N132BCUniversidad Interamericana De Puerto Rico · Bayamon, PRBuilt 2003 · S/N 2843583 N132CACoast Flight Training And Management Inc · San Diego, CABuilt 2020 · S/N 2881354 N132CPBalanced Speed LLC · Flower Mound, TXBuilt 2006 · S/N 1715 N132DRAasap Construction Co Inc · Conway, SCBuilt 1980 · S/N 32R-8029108 N132DSManrin Aviation LLC · Dublin, CABuilt 2004 · S/N 40.450 N132DWChristiansen Aviation LLC · Wilmington, DEBuilt 2002 · S/N 4496139 N132GMSky West Aviation Inc Trustee · Albuquerque, NMBuilt 2003 · S/N 3257335 N132GTLegal Eagle 2 LLC · Jefferson City, MOBuilt 2007 · S/N 3257447 N132HSCentral Virginia Aviation Inc · Petersburg, VABuilt 1972 · S/N LW-8 N132JMTvpx Ars Inc Trustee · North Salt Lake, UTBuilt 2025 · S/N 10631 N132JSAbc Flight LLC · Helena, MTBuilt 2024 · S/N 9900 N132LTCobblestone Capital Aviation LLC · Sylacauga, ALBuilt 2011 · S/N 4636493 N132MDA1 Aero Inc · Parkland, FLBuilt 2025 · S/N 10846 N132MTMiddle Tennessee State University · Murfreesboro, TNBuilt 2022 · S/N 4496540 N132RFTom-Wolverton Matthew J · Morris Plains, NJBuilt 2002 · S/N 0298 N132STGrande Aviation LLC · Englewood, FLBuilt 2005 · S/N 3232035 N132TTN132tt Inc · Los Angeles, CABuilt 2002 · S/N 1196

Back to AD 2008-06-28 R1