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.

N180XRBank Of Utah Trustee · Salt Lake City, UTBuilt 1954 · S/N 30743 N18118Bokman Charles J III · Athol, IDBuilt 1977 · S/N 18503328 N1811DRegistration Pending · Kennedale, TXRegistration pending, canceledBuilt 1981 · S/N EA-237 N1812QLiv2fly LLC · Grand Junction, COBuilt 1975 · S/N U20602936 N1814EErda LLC · Wilmington, DEBuilt 1981 · S/N EA-241 N1815LEagles Rise Aviation LLC · Wales, MAS/N TJ-63 N1817AKlinefelter Kristopher J · Phoenix, AZBuilt 1981 · S/N EA-243 N1817ZOrr Lynn E · Fredericksburg, OHBuilt 1981 · S/N TJ-386 N1818XBeech Jet 324 LLC · Delray Beach, FLBuilt 2000 · S/N E-3302 N1819MDjb Asset Management LLC · Oakdale, CABuilt 1981 · S/N EA-245 N181AMMolny Adam J · Naples, FLBuilt 2012 · S/N L2K-151 N181BCBlue Chip Aviation Services LLC · Cincinnati, OHBuilt 2026 · S/N 11143 N181CCLegacy Air Services LLC · Lafayette, LABuilt 2019 · S/N 2017 N181DBPleasant City Aviation LLC · Shelby, NCBuilt 2020 · S/N 2212 N181JRCavu Clearing LLC · Palm Coast, FLBuilt 1982 · S/N TJ-363 N181JWSkyhaven Aviation LLC · Steamboat Springs, COBuilt 2009 · S/N 3591 N181KTRegistered aircraftBuilt 2000 · S/N 30-0056 N181MCTf1 LLC · Pittsford, NYBuilt 2018 · S/N 4720 N181MKHarlow Builders Inc · Troy, OHBuilt 2015 · S/N 1105 N181SPIkway Air LLC · St Charles, ILBuilt 2023 · S/N 9121 N181TXAddie-Air Inc · Bridgeport, TXBuilt 1981 · S/N U20606408 N181WRunway Group LLC · Bentonville, ARBuilt 2013 · S/N 0675 N181WTMeadows Robert K · Macon, GABuilt 2003 · S/N 0638 N1821EHth Companies Inc · Union, MOBuilt 1979 · S/N 310R1581 N1822FFoxtrot Tango Aviaiton LLC · West Palm Beach, FLBuilt 2024 · S/N 10270 N1824NMaiorana Anthony J Trustee · Clarkston, WABuilt 1981 · S/N EA-248 N1826VBig Blue Sky Aero LLC · Austin, TXBuilt 1997 · S/N E-3086 N18280Team Holdings Inc · Sheridan, WYBuilt 1977 · S/N TJ-112 N182SZHigh Wing Aviation LLC · Phoenix, AZBuilt 1974 · S/N 18263278 N1830VStress Aircraft Holdings LLC · Pilot Mountain, NCBuilt 1997 · S/N E-3087 N1830ZJaju Aviation Inc · Abilene, TXBuilt 1981 · S/N TJ-379 N1835SEagles Flying Club Inc · San Francisco, CABuilt 1984 · S/N EA-419 N183BMAircraft Guaranty Corporation Trustee · Oklahoma City, OKBuilt 2014 · S/N 4080 N183CACloud Asset LLC · Thomasville, GABuilt 2026 · S/N 11195 N183CDRegistered aircraftBuilt 2004 · S/N 0921 N183KSN183ks LLC · Houston, TXBuilt 2019 · S/N 1891 N183PHVestal Aviation LLC · Thomasville, NCBuilt 2010 · S/N 0062 N183SFGrand Cove Support Services LLC · Denver, COBuilt 2018 · S/N 1737 N183SRRyder Aviation LLC · Tucson, AZBuilt 2025 · S/N 10401 N183VGriffiths Aero LLC · Centerville, OHBuilt 2008 · S/N 3125 N183XIcg Aviation LLC · Ankeny, IABuilt 2017 · S/N 1479 N1842SFry William A · Willmar, MNBuilt 1973 · S/N 414-0433 N1843LRegistered aircraftS/N TJ-65 N1847HQuantum Fly Corp · Boca Raton, FLS/N TK-145 N18499Austin Aviation LLC · Boise, IDBuilt 1983 · S/N EA-362 N184AJFour Alpha Juliet LLC · Minster, OHBuilt 2004 · S/N E-3578 N184DMRegistered aircraftBuilt 1998 · S/N E-3199 N184JPSarita Aerial Contractors Inc · Casa Grande, AZBuilt 1979 · S/N 18052889 N184KTDsm Asset Management LLC · Fort Worth, TXBuilt 2003 · S/N 0477 N184MCWest Houston Flippers LLC · Dallas, TXBuilt 2014 · S/N 0962

Back to AD 2012-10-13