Registered aircraft · 13,306

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:2012-10-13') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2012-10-13') 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:2012-10-13')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2012-10-13')
  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:2012-10-13')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2012-10-13')
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.

N234HKExplore Aviation LLC · Santa Barbara, CABuilt 2006 · S/N 1746 N234JFaliero Bryan K · Greenville, SCBuilt 2025 · S/N 10754 N234KBRegistration Pending · Wenatchee, WARegistration pendingBuilt 2026 · S/N 11440 N234KRRhume LLC · Carson, CABuilt 2023 · S/N 9460 N234KTCessna 182 LLC · Kitty Hawk, NCBuilt 2004 · S/N 41023 N234MJMj Aviation LLC · Mooresville, NCBuilt 2018 · S/N 1673 N234MSVertical Horizon Aviation LLC · Sandown, NHBuilt 1975 · S/N 3400351 N234PDAccurite Machine & Manufacturing Inc · Louisville, KYBuilt 2004 · S/N 1167 N234PGSpeer Aircraft LLC · Evansville, INBuilt 2004 · S/N 0935 N234PSTkn Holdings LLC · Pima, AZBuilt 1977 · S/N 340A0368 N234PTJaguar Management Group LLC · Wilmington, DEBuilt 2000 · S/N EA-662 N234PYAqua Aviation LLC · Winnetka, ILBuilt 2019 · S/N 1908 N234SASun Valley Energy Investments LLC · Gainesville, GABuilt 2024 · S/N 10372 N234SBDaly Arthur P · El Paso, TXBuilt 1981 · S/N P21000673 N234SDHerndon Aviation LLC · Kokomo, INBuilt 1981 · S/N EA-200 N234TCAg N234tc LLC · South Salt Lake, UTBuilt 1974 · S/N 310R0050 N234TTGloyna Edwin Scott · Lubbock, TXBuilt 2020 · S/N 2049 N234WIwaa Inc · Woodstock, GABuilt 1976 · S/N 21061618 N234WSMancini Gary Ray · Livermore, CABuilt 2004 · S/N 29-0343 N234XLCirrus Design Corp · Duluth, MNBuilt 2026 · S/N 11503 N2352YMilton Jerry D · Lillington, NCBuilt 1998 · S/N TH-1865 N2354FBarbee William Terry · Weslaco, TXBuilt 1998 · S/N E-3154 N2355TBe-3195 LLC · Conway, ARBuilt 1998 · S/N E-3195 N2357NCreviston Steven Eric · Greensboro, NCBuilt 1998 · S/N E-3157 N2358KSmith Aeromotive Charters Inc · Excelsior, MNBuilt 1997 · S/N TH-1827 N2359LJ & M Baling Inc · Farmington, NMBuilt 1998 · S/N E-3159 N235DRegistration Pending · Mead, CORegistration pendingBuilt 1978 · S/N TJ-134 N235EGHch Aircraft LLC · El Paso, TXBuilt 1985 · S/N EA-443 N235SKInde Aviation LLC · Chesterfield, VABuilt 2023 · S/N 9372 N235WJmzb Leasing LLC · Amarillo, TXBuilt 1979 · S/N 21063206 N235WHTail Aero Corp · Wilmington, DEBuilt 1977 · S/N 21061797 N235WTNelson John R · Bedford, NHBuilt 2023 · S/N 9061 N236ATN236at LLC · Miami, FLBuilt 1975 · S/N 414-0805 N236BBLpb Aviation LLC · Austin, TXBuilt 2023 · S/N 9366 N236CBCarlson Aviation LLC · Dubois, PABuilt 2021 · S/N 2336 N236DCGilbert Gerald · Falls Church, VABuilt 2012 · S/N 3836 N236DRVargyas Aviation LLC · Michigan City, INBuilt 2017 · S/N 1620 N236HPProctor John M · Spotsylvania, VABuilt 1987 · S/N E2399 N236LLaux Air LLC · Missoula, MTBuilt 2004 · S/N 0810 N236LLFrenjc LLC · Sedona, AZBuilt 2002 · S/N L2K-158 N236PTmg Investment Properties LLC · Surprise, AZS/N P21000116 N236RMConrad Harold M · Sugar Grove, ILBuilt 1979 · S/N EA-43 N236RSSchoombee Clinton John · Murrieta, CABuilt 2004 · S/N 41003 N236STOutdoor Metal Products LLC · Leighton, ALBuilt 1968 · S/N 401A0020 N236WBt1 Air LLC · Grover Beach, CABuilt 2002 · S/N E-3432 N2375SLundin Lawrence D · Midvale, IDBuilt 1976 · S/N 21061257 N237CDC5 Holding LLC · San Juan, PRBuilt 2026 · S/N 11582 N237CGSonoma Valley LLC · Missoula, MTBuilt 2008 · S/N 2934 N237JAJacvia Aircraft Inc · Scottsville, KYBuilt 2025 · S/N 11051 N237LPGallatin Consulting Group LLC · Pittsburgh, PABuilt 2020 · S/N 2200

Back to AD 2012-10-13