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.

N184MGClt Aviation LLC · Loxahatchee, FLBuilt 2018 · S/N 1676 N184PKChucks Transport LLC · Kalispell, MTBuilt 2007 · S/N 2802 N184PMMccoy Michael A · Granbury, TXBuilt 2016 · S/N 1234 N184TMYates Christopher R · Huntington Beach, CABuilt 1956 · S/N 32302 N1850JWailea Aircraft LLC · Kamuela, HIBuilt 1981 · S/N EA-268 N1854WRona-B LLC · Scottsdale, AZBuilt 1981 · S/N EA-269 N1856EGv Air Inc · Medford, ORBuilt 1979 · S/N 310R1591 N1856TCohan Peter E · Trinidad, CABuilt 2015 · S/N 4279 N1858PBaron N1858p LLC · Fresno, CABuilt 1981 · S/N TJ-372 N185AMLanham Douglas S · Santa Fe, NMBuilt 1974 · S/N 18502529 N185BABerk Aviation LLC · Phoenix, AZBuilt 1978 · S/N 18503498 N185BBBeiter Paul R · Ellensburg, WABuilt 1977 · S/N 18503449 N185BRDelta Sierra LLC · Waterloo, NEBuilt 1979 · S/N 18503900 N185CXRoark Michael · Bremerton, WABuilt 1980 · S/N 18504060 N185FBBurchardi Michael Edward · Santa Ynez, CABuilt 1975 · S/N 18502580 N185MTMarsh Douglas C · Omak, WABuilt 1975 · S/N 18502672 N185RAA-T Enterprises Ltd · Three Forks, MTBuilt 1967 · S/N 185-1209 N185SZBredin Thomas W · Anchorage, AKBuilt 1969 · S/N 185-1589 N185TJMuchow Craig R · Gooding, IDFirst renewal noticeBuilt 1969 · S/N 185-1532 N185WZB H Hildebrand Construction Inc · Cataldo, IDBuilt 1980 · S/N 18504102 N1862BLow Key Aero LLC · Laingsburg, MIBuilt 2011 · S/N 3753 N1865LLiberty Partners Inc · Okmulgee, OKS/N TK-14 N186CGPine Needle Air LLC · Santa Rosa Beach, FLBuilt 2016 · S/N 1443 N186CKPuckett David Bryan · Ellensburg, WABuilt 2009 · S/N 3441 N1879LN1879l LLC · Missoula, MTBuilt 1976 · S/N TK-13 N187AJAviation Trust Co LLC Trustee · Oklahoma City, OKBuilt 2016 · S/N 4356 N187CSNorris Marvin D · Georgetown, TXBuilt 1999 · S/N E-3232 N187SRSpirit Property Development LLC · Addison, TXBuilt 2006 · S/N 1950 N1880E L I Land Design LLC · Montgomery, TXBuilt 2001 · S/N 0110 N188AJA&J Specialties LLC · Hickory, PABuilt 2025 · S/N 10762 N188LSJms Small Aircraft Fl LLC · Aventura, FLBuilt 2022 · S/N 8933 N188MAAviation Leasing LLC · Erie, COBuilt 2008 · S/N 3096 N188MGMarkusair Leasing LLC · Wilmington, DEBuilt 2018 · S/N 32-0006 N188MHAndree'S Avion LLC · Santa Fe, NMBuilt 2013 · S/N 0499 N188RCHodgskies Holdings LLC · Choteau, MTBuilt 1984 · S/N E-2189 N188SRRogers Steven Trustee · Ogden, UTBuilt 1978 · S/N 340A0636 N188WW3l0 Air LLC · Chuluota, FLBuilt 1976 · S/N TJ-67 N18916Valiair Lc Trustee · Casper, WYBuilt 2006 · S/N 2075 N1894EDelvest LLC · Grosse Pointe, MIBuilt 1979 · S/N 340A0662 N1895LPalm Group LLC · Metairie, LABuilt 1977 · S/N TH-894 N1896LGolf Lima Aviation LLC · Port Angeles, WABuilt 1976 · S/N TK-16 N189FTeag Leasing LLC · Edmonds, WABuilt 2001 · S/N EA-680 N189FGAerotech Coatings LLC · Arlington, WABuilt 2016 · S/N 4378 N189MCThree Thirty Three LLC · Wilmington, DEBuilt 2010 · S/N 0045 N189MKS2ar Aviations LLC · Lantana, FLBuilt 1978 · S/N 414A0100 N189PWArrivee LLC · Manhattan Beach, CABuilt 2019 · S/N 1964 N189STSierra Tango Aviation LLC · Colleyville, TXBuilt 2026 · S/N 11452 N18AS1607 Vistas LLC · Fort Lauderdale, FLBuilt 2023 · S/N 9059 N18AVAdvanced Aviation LLC · Merrick, NYBuilt 2018 · S/N 4729 N18BCT-Air LLC · Schofield, WIBuilt 2024 · S/N 10119

Back to AD 2012-10-13