Registered aircraft · 13,311

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.

N1033QKuhn Marcus J · Madison, WIBuilt 2003 · S/N 29-0310 N1035NHiggins Michael S · Palatine, ILBuilt 2003 · S/N 29-0305 N10368S-A Clark Aviation LLC · Fort Smith, ARBuilt 2002 · S/N 29-0286 N1036RYork Aviation LLC · Asheboro, NCBuilt 2003 · S/N 29-0302 N1039GFountain Keith E · Jacksonville, NCBuilt 1979 · S/N 21063174 N1039SJohnson Robert E Jr · Southport, NCBuilt 2003 · S/N 29-0318 N103BKFalcon Avion LLC · Paragould, ARBuilt 2025 · S/N 10668 N103CClarity Its LLC · Canton, GABuilt 2002 · S/N 0432 N103EECirrus Djh LLC · Bountiful, UTBuilt 2006 · S/N 2104 N103FDMidnight Echo LLC · Miami Lakes, FLBuilt 2024 · S/N 9838 N103FPStyle Ventures LLC · Lafayette, LABuilt 2006 · S/N 42512 N103HMNoblett Ronald D · Bellaire, TXBuilt 2002 · S/N L2K-121 N103JGRam Aero Development Inc · Waco, TXBuilt 1979 · S/N 414A0264 N103KEuroaviation Inc Trustee · KematenBuilt 2023 · S/N 10193 N103LCKenmore Crew Leasing Inc Trustee · Bellingham, WABuilt 2021 · S/N 2281 N103LLMoghaddas Ali · Westlake Village, CAS/N L2K-182 N103MK2141 Corp · Wilmington, DEBuilt 2005 · S/N 1444 N103RMValiair Lc Trustee · Casper, WYBuilt 1975 · S/N 310R0109 N1040WFoolish Pleasure Aviation Inc · Lewes, DEBuilt 1979 · S/N D-10203 N10419C Flying K Aviation LLC · Black Hawk, COBuilt 1976 · S/N T21061484 N10422Jackson Benjamin Tillman · Rancho Mirage, CABuilt 2004 · S/N 29-0323 N1042TJbr Leasing Inc · Orlando, FLBuilt 1976 · S/N TJ-79 N1044VTigers Air Inc · Fairfax Station, VABuilt 2003 · S/N 29-0317 N1045FOpc Consulting LLC · Hickory Corners, MIBuilt 2001 · S/N 29-0273 N1045XServaty Frank R · Canyon Lake, TXBuilt 2000 · S/N 29-0232 N10469Airscout LLC · Valdosta, GABuilt 2004 · S/N 29-0336 N1046VSusitna Air Service LLC · Anchorage, AKBuilt 1974 · S/N U20602418 N1047LMcneill Philip · Reston, VABuilt 2003 · S/N 29-0320 N104BZSterling Aviation LLC · Newport Beach, CABuilt 2004 · S/N 1219 N104ETLmc Angels LLC · Hinckley, OHBuilt 2004 · S/N 1024 N104FMEide Machinery Sales Inc · Minneapolis, MNBuilt 1999 · S/N E-3275 N104FPAutowashlbt LLC · Lumberton, NCBuilt 2006 · S/N 42513 N104GHBluff Point Aviation LLC · Jensen Beach, FLBuilt 2014 · S/N 4087 N104PPToledo Public Schools · Swanton, OHS/N 41086 N104RCChan Ronald G · Anchorage, AKBuilt 1966 · S/N 1851098 N104SVCrete Solutions LLC · Wilmington, NCBuilt 2025 · S/N 11053 N104TQGtw Aviation LLC · San Jose, CABuilt 2006 · S/N 2304 N104WDHill Keith D · Kirby, ORBuilt 1979 · S/N P21000366 N10502Flying Chipmunk LLC · Charlotte, NCBuilt 2025 · S/N 10502 N1052AKraken Aviation LLC · Camden, DEBuilt 2016 · S/N 1333 N1053LKutzleb Michael K · Fernandina Beach, FLBuilt 2000 · S/N 29-0261 N1054CCumberland Curtis · Union Bridge, MDBuilt 2003 · S/N 29-0296 N1054KBondy William G · Miami Beach, FLBuilt 2000 · S/N 29-0266 N1056TTierno Patrick Louis · Seaford, DES/N 30-0065 N1058RWindle Air Baron LLC · Lynchburg, VABuilt 1996 · S/N TH-1791 N105CKHdm Aviation LLC · Saratoga, CABuilt 2016 · S/N 4399 N105DFWestwood Aero Inc · Porterville, CABuilt 1986 · S/N 21064999 N105GCCirrus Design Corp · Duluth, MNBuilt 2025 · S/N 11013 N105HCJi Aviation LLC · Vidalia, LABuilt 2019 · S/N 4777 N105KLWing It LLC · Madison, WIBuilt 2017 · S/N 4461

Back to AD 2012-10-13