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.

N1936HBarts Flying Service · Storm Lake, IABuilt 1977 · S/N 28-7716066 N1937BPiper Aircraft Inc · Vero Beach, FLBuilt 2025 · S/N 4636858 N1937HTerra Alfred Jr · Taunton, MABuilt 1977 · S/N 28-7790358 N1937KGriffin Contracting Co · Bloomfield, MOS/N 3213091 N1939GMorgan Larry D · Blair, NEBuilt 1989 · S/N 2890107 N193CAVision Air Leasing LLC · Newport Beach, CABuilt 2006 · S/N 40.687 N193DWGilbert Louis Vincent · Houston, TXBuilt 2004 · S/N 42043 N193JPMullan John C · Edina, MNBuilt 2003 · S/N 40.293 N193KCBig Blessing II LLC · Saint Louis, MOBuilt 2022 · S/N 8857 N193LHPiper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 28010067 N193SFBlue Castle Properties LLC · Littleton, COBuilt 2012 · S/N 4636567 N193SRScreaming Eagle Aviation Inc · Webb City, MOBuilt 2007 · S/N 2663 N193WTHovland Patrick John · Munster, INBuilt 2002 · S/N 1165 N1941VSale Reported · Bloomburg, TXSale reported, canceledBuilt 1984 · S/N 28-8490056 N1942JFlybird LLC · East Northport, NYBuilt 2003 · S/N 3246216 N1946HMacair Aviation LLC · Xenia, OHBuilt 1977 · S/N 28-7716067 N194CDLehmar LLC · New Orleans, LABuilt 2004 · S/N 1027 N194CMPlanejohn LLC · Minnetonka, MNBuilt 2006 · S/N 1882 N194CPSkywest Aviation Inc Trustee · Albuquerque, NMBuilt 2008 · S/N 3059 N194GSMaster Aviation LLC · Intl Falls, MNBuilt 2022 · S/N 2881515 N194HPHighwood Consulting Group Inc · Bedford, NHBuilt 1993 · S/N 3213043 N194LFRidan Investments Inc · Boerne, TXS/N 41630 N194LGSunshine Sky Aviation LLC · Doral, FLBuilt 2006 · S/N 2179 N194MAJb Air Inc · Manhattan, KSBuilt 2001 · S/N 3246194 N194PMDye David A · Point Clear, ALBuilt 1993 · S/N 4622146 N194TSUtah State University · Logan, UTBuilt 2008 · S/N 40.972 N19500Wright Bros Flying Club LLC · Lewes, DEBuilt 1994 · S/N 4622163 N1951GClassic Aviation Inc · Pella, IABuilt 2003 · S/N 0630 N1952KWard & Ward Management Consultants Inc · Sparta, TNBuilt 2002 · S/N 0147 N1959HN1959h Aviation LLC · Hillsborough, NJBuilt 1977 · S/N 28-7790361 N195AJ195aj LLC · Toledo, OHBuilt 1995 · S/N 3213096 N195AMSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 2010 · S/N 4692146 N195CDGemini Aviation LLC · Brownsburg, INBuilt 2000 · S/N 1089 N195JGN195jg Aviation LLC · Port Republic, NJBuilt 1994 · S/N 4622173 N195MASkywest Leasing Inc · St George, UTBuilt 2018 · S/N 2881029 N1961JCullen Stephen · Washington, INBuilt 1978 · S/N 28-7890476 N19626Cirrus Design Corp · Duluth, MNS/N 11717 N1963EPrideaux Paul M · Henrico, VABuilt 2008 · S/N 3082 N1963MN1963m LLC · Torrance, CABuilt 2002 · S/N 0355 N1966Angel Aviation Flights LLC · Indian Trail, NCBuilt 2025 · S/N 10676 N1966MRomeo Whiskey LLC · Wilmington, NCBuilt 2021 · S/N 5142 N1968WPtt Aircraft Management Inc · Newport Beach, CABuilt 2001 · S/N 4697115 N1969HTrn Aviation LLC · Mcallen, TXS/N 3257066 N1969PPie In The Sky Aviation LLC · Eads, TNBuilt 2007 · S/N 2481 N196AMP&W Investments Inc · Wilmington, DEBuilt 2000 · S/N 1105 N196HPSouthtrust Adventures LLC · Pensacola, FLBuilt 1996 · S/N 3246028 N196MCBond Heather Temperance · Knoxville, TNBuilt 2010 · S/N 2071 N196SRWhen Elephants Fly LLC · Camden, DEBuilt 2007 · S/N 2750 N1970Ils 22l LLC · Miami Beach, FLBuilt 2001 · S/N 0063 N1970HCape Fear Aviation Maintenance LLC · Fayetteville, NCBuilt 1977 · S/N 28-7716071

Back to AD 2008-06-28 R1