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.

N175MHCharlie Michaels LLC · Helena, MTBuilt 2023 · S/N 9467 N175SPN500aa LLC · Wilmington, DES/N 414A0313 N175USAtlas Property Management LLC · Broken Arrow, OKS/N 0570 N1767PSteciuk Paul B · Saratoga Springs, NYBuilt 2011 · S/N 0133 N176CFMbg Capital Holdings LLC · West Des Moines, IAS/N 3757 N176KMAssociated Packaging Inc · Gallatin, TNBuilt 2019 · S/N 1851 N176MMRair Air Inc · Stateline, NVBuilt 1976 · S/N 310R0710 N176PSJr Barragan Inc · Chowchilla, CABuilt 2006 · S/N 2249 N176QBse & Associates Inc · Sacramento, CABuilt 2019 · S/N 1898 N176WEFlying D Labs LLC · Bend, ORBuilt 2016 · S/N 1283 N1776MBidfish Ventures LLC · Harrisonburg, VABuilt 2005 · S/N 1394 N1776XAgl Aviation LLC · Temecula, CABuilt 2023 · S/N 9492 N1778UMission Aviation Fellowship · Nampa, IDS/N 20700378 N177DGHesperia Construction Inc DBA · Ramona, CABuilt 1979 · S/N TJ-241 N177PEPicabo Livestock Co · Picabo, IDBuilt 1979 · S/N P21000334 N177PTJohn Walter Finley · Mcconnelsville, OHBuilt 2007 · S/N 2861 N1781ECallaham John · Broken Bow, OKBuilt 1979 · S/N 310R1571 N1782URbr Aircraft Inc · Albuquerque, NMS/N 21064744 N1783JReady Air Inc · Bellevue, WABuilt 2008 · S/N 3293 N1786XS K Cattle Co · Manhattan, KSBuilt 1975 · S/N 21060806 N178ATFraser Jamie A · Nokomis, FLBuilt 2024 · S/N 9813 N178CATeddymax LLC · Sarasota, FLBuilt 2026 · S/N 11194 N178RDHelicopter Consultants Inc · Union, WABuilt 1979 · S/N 21063445 N1798ZCirrus Design Corp · Duluth, MNBuilt 2026 · S/N 11602 N179JDFarnborough Aircraft Inc Trustee · Wilmington, DEBuilt 2017 · S/N 1527 N17AMFarmdog Aviation LLC · Lafayette, INBuilt 1974 · S/N 414-0524 N17DARegistration Pending · Pecos, NMRegistration pendingBuilt 2024 · S/N 10329 N17DTFinney Aviation LLC · Bloomington, INBuilt 2019 · S/N 1974 N17EARegistration Pending · Melbourne, FLRegistration pendingBuilt 1997 · S/N E-3092 N17ECLinggi Asset Holdings LLC · Sheridan, WYBuilt 2026 · S/N 11421 N17ESCrimson Aviation LLC · New York, NYBuilt 1985 · S/N TJ-488 N17EUCirrus Design Corp · Duluth, MNBuilt 2026 · S/N 11409 N17GPRed River Partners LLC · Edmond, OKBuilt 1979 · S/N TJ-210 N17JGSkyward Holdings Inc · Miami Beach, FLBuilt 2019 · S/N 4771 N17JJN17jj LLC · Punta Gorda, FLBuilt 2004 · S/N L2K-229 N17KDAht Aviation LLC · Doral, FLBuilt 2020 · S/N 2065 N17KEYanity Nicholas A · Woodinville, WABuilt 2005 · S/N 1358 N17NGParmer Construction Company LLC · Terrell, TXBuilt 1987 · S/N 4608074 N17NWEye Clinic Building Lllp · Bismarck, NDBuilt 1979 · S/N 414A0223 N17SNWindspeed LLC · Amarillo, TXBuilt 2001 · S/N 0115 N17UKSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 2002 · S/N 0200 N1800HSanders Trent J · Redway, CABuilt 2003 · S/N 42009 N1805DDodson International Parts Inc · Rantoul, KSBuilt 1981 · S/N EA-233 N1806DGold Coast Logistics LLC · St Simons Island, GABuilt 1981 · S/N TJ-364 N1807BCloud Nine Corp · Batesville, INBuilt 1981 · S/N EA-234 N1807FTurboflyers Inc · Leesburg, VAFirst renewal noticeBuilt 1981 · S/N EA-235 N1808QBearspoint LLC · Edmond, OKS/N EA-236 N1808RFlorida Fence Corp · Tavernier, FLS/N TJ-366 N180BADavis Robert D · Camas, WAS/N 18052419 N180BZFlying Red Birds LLC · Framingham, MABuilt 2003 · S/N 0714

Back to AD 2012-10-13