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.

N1625CK&C Technologies LLC · Belleville, WIBuilt 2003 · S/N 0584 N1625UFly2k LLC · San Jose, CABuilt 1982 · S/N 21064710 N1627TSierra Leasing LLC · Sheffield, ALBuilt 1973 · S/N 414-0407 N1628ZVertex Aviation LLC · Kodiak, AKBuilt 1962 · S/N 185-0428 N162BFlight 19 LLC · Atlanta, GABuilt 2024 · S/N 10375 N162CFGroeneveld Lisa · South Burlington, VTBuilt 2025 · S/N 10769 N162CMBorror Aaron · Fort Rock, ORBuilt 2008 · S/N ES-168 N162DFFaford Aviation Leasing Co · Atherton, CABuilt 1982 · S/N TJ-403 N162JBGjm Aviation LLC · Petal, MSBuilt 2022 · S/N 8579 N162SR3 Brothers Plaza LLC · Nice, CABuilt 2006 · S/N 2088 N162VPVirunga Airwing LLC · Washington, DCS/N U20606215 N1633XRhodes Donald P · Fort Worth, TXBuilt 1975 · S/N 21060669 N1634XBadwater Ranch Inc · Lysite, WYBuilt 1975 · S/N 21060670 N1636JBrc Holdings LLC · La Follette, TNBuilt 2017 · S/N 4541 N1636XMonke Farm & Cattle Co · Nickerson, NEBuilt 1975 · S/N 21060672 N1636ZConstantine Paul John Jr · Anderson, SCBuilt 2022 · S/N 8590 N1637TSmith Taylor · Amarillo, TXBuilt 1973 · S/N 414-0417 N163SDAre You Cirrus LLC · Glasgow, MTBuilt 2013 · S/N 0662 N1646TOrellana Willson Daniel · Hesperia, CABuilt 1973 · S/N 414-0426 N164BBPorter Patrick J · Greensboro, NCBuilt 2004 · S/N 1128 N164CPHighwings LLC · West Fargo, NDBuilt 2014 · S/N 0891 N164CTBuckley Aviation LLC · Swainsboro, GABuilt 2016 · S/N 1267 N164KFValiair Ltd Co Trustee · Casper, WYBuilt 2016 · S/N 1320 N164KXN164kx LLC · Charlotte, NCBuilt 2015 · S/N 1064 N164TBBuzza Tim · Cudjoe Key, FLBuilt 2020 · S/N 2094 N1652TBas Part Sales LLC · Greeley, COBuilt 1973 · S/N 414-0432 N1652XBlackbridge Holdings LLC · Helena, MTBuilt 1975 · S/N 21060687 N1655XApostolou Gregory · Henderson, NVBuilt 1975 · S/N 21060690 N1657XRowe William W · Provo, UTBuilt 1975 · S/N 21060692 N165FDEck Management Company LLC · Kingman, KSBuilt 2025 · S/N 10565 N165JBN165jb LLC · Dayton, OHBuilt 2024 · S/N 10237 N165JVHigh Desert Aviation And Aerobatics LLC · Pocatello, IDBuilt 1998 · S/N E-3180 N165LMSig Cirrus LLC · Powell, OHBuilt 2014 · S/N 0960 N165LRAircraft Trustee Services Inc Trustee · Dover, DES/N 0632 N165MWN723 LLC · Denver, COBuilt 2016 · S/N 1420 N165SRN165sr LLC · Waterford, VABuilt 2006 · S/N 1941 N1663COlson Aviation LLC · Chandler, AZBuilt 2003 · S/N 0585 N1665CTaylorsville Lake Marina Inc · Simpsonville, KYBuilt 2003 · S/N 0587 N1668TKevu Aviators LLC · Maryville, MOBuilt 1973 · S/N 414-0461 N166BGColumbia Asset Trust Corp Trustee · Wichita, KSBuilt 2023 · S/N 9505 N166BVSensing Aviation LLC · Nashville, TNBuilt 2000 · S/N TH-1958 N166CAMca Aviation LLC · Cartersville, GABuilt 2026 · S/N 11117 N166MDDoan Aviation LLC · New Hope, PABuilt 2024 · S/N 10260 N166RTTalgrad Aviation LLC · Cumming, GABuilt 2007 · S/N 2687 N166SMRegistered aircraftRegistration pending, pending cancellationBuilt 2023 · S/N 9461 N166TRBourn Bryan · Jordan, MNBuilt 2002 · S/N 0264 N166ZUsda Forest Service Fire & Aviation · Boise, IDBuilt 1986 · S/N U20606923 N1670THyde Family Aviation LLC · Wilmington, DEBuilt 1973 · S/N 414-0463 N1675XNo Runways LLC · Iraan, TXBuilt 1975 · S/N 21060710 N1676UDigicam Co · Henderson, NVBuilt 1982 · S/N 21064724

Back to AD 2012-10-13