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.

N224TGPlaneview LLC · Fountain Hills, AZBuilt 2005 · S/N 1570 N224UQue Estaran Haciendo LLC · North Miami, FLBuilt 2008 · S/N 3129 N224W0262 Aviation Inc Trustee · Wilmington, DEBuilt 2024 · S/N 10046 N224WSEagle Aero LLC · Green Bay, WIBuilt 2022 · S/N 8807 N224WTSkizer Inc · Marina Del Rey, CABuilt 2006 · S/N 1947 N224YBFly Robin Fly LLC · Marietta, GABuilt 2025 · S/N 11048 N2252SSpider Lips Aviation LLC · Fischer, TXBuilt 1976 · S/N 21061196 N2255Cirrus Design Corp · Duluth, MNBuilt 2026 · S/N 11530 N2255TC4 Holdings Group LLC · Odessa, FLBuilt 2023 · S/N 9073 N2258JPluhar Darrin P · Ekalaka, MTBuilt 1979 · S/N T18803441T N2259RLarson Lianne N · Irvine, CABuilt 1968 · S/N T210-0409 N2259SFaireyfam Aviation LLC · Saint George, UTBuilt 1976 · S/N 21061203 N225ALM&M Capital LLC · Palm City, FLBuilt 2020 · S/N 2130 N225CRQualitair LLC Trustee · MichelstadtBuilt 1982 · S/N EA 317 N225FSmall Inc · Senath, MOBuilt 2016 · S/N 4330 N225FDHoldings Excellence LLC · Frostproof, FLBuilt 2023 · S/N 9167 N225HLPalladium Air LLC · Orlando, FLBuilt 2020 · S/N 2201 N225JWTalbot Larry · Lakewood Ranch, FLBuilt 2001 · S/N E-3418 N225MKOxford Advisory Aviation LLC · Orlando, FLBuilt 2014 · S/N 0724 N225PSalem Aviation LLC · Winston Salem, NCBuilt 1997 · S/N EA-608 N225PETspy Services Inc · Wilmington, DES/N 4286 N225PLHebert Michael Paul · Bothell, WABuilt 2017 · S/N 1546 N225RBN225rb Corp Trustee · Wilmington, DEBuilt 2010 · S/N 0010 N225TLChute Happens LLC · Annandale, VABuilt 2017 · S/N 4478 N225TNA C Leonard LLC · Missoula, MTBuilt 2008 · S/N 3108 N225VTSls Travel LLC · Missoula, MTBuilt 2017 · S/N 4448 N2260SWheeler Eugene N · Livermore, CABuilt 1976 · S/N 21061204 N2262SKoch Phillip E · Eldon, MOBuilt 1976 · S/N 21061206 N22650Sackett Gary G · Millcreek, UTFirst renewal noticeBuilt 1972 · S/N 21059767 N2266SWeekend Air LLC · Incline Village, NVBuilt 1976 · S/N 21061210 N2268CCozach LLC · Wilmington, DEBuilt 1982 · S/N T30300081 N2268MMorgan Kinder LLC · Friendswood, TXBuilt 2003 · S/N 0642 N226BBSky West Aviation Inc Trustee · Albuquerque, NMBuilt 2009 · S/N 3426 N226BCBrown John D · Parkersburg, WVBuilt 2006 · S/N 1826 N226BGMahoney Timothy P · Nantucket, MABuilt 2004 · S/N 0837 N226BRValiair Lc Trustee · Casper, WYBuilt 2025 · S/N 10662 N226CFWendler William F II · Bridgton, MEBuilt 2021 · S/N 4994 N226CHDraper Michael John · Chenoa, ILBuilt 2004 · S/N 0875 N226FDBlue Mountain Aviation LLC · Newark, DEBuilt 2023 · S/N 9105 N226HPRegistration Pending · Valdosta, GARegistration pendingBuilt 1978 · S/N 414A0084 N226JHAmeritech Flight Services LLC · Hummelstown, PABuilt 2009 · S/N 3443 N226KBBex Investments LLC · Oklahoma City, OKS/N 4746 N226MLSierra Kilo Capital Holdings LLC · Arvada, COBuilt 2020 · S/N 2052 N226MMKdf Air LLC · Missoula, MTBuilt 2020 · S/N 2138 N226NSdj LLC · Mercer Way, WABuilt 2024 · S/N 9854 N226PKCirrus Design Corp · Knoxville, TNBuilt 2016 · S/N 1471 N226PMClrmet Partners LLC · Lindon, UTBuilt 2019 · S/N 1868 N226RHHarding Christopher · Houston, TXBuilt 2006 · S/N 2290 N226SBSb Sierra Partners LLC · Santa Barbara, CABuilt 2022 · S/N 8549 N226SCJohnson Lansworth P · Jackson, WYBuilt 1984 · S/N EA-406

Back to AD 2012-10-13