Registered aircraft · 13,307

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.

N12DUWoodtick Summit Aviation LLC · Redmond, ORBuilt 1979 · S/N U20605202 N12EDKinney Aviation LLC · Bethany Beach, DEBuilt 2026 · S/N 11420 N12ENGallagher John · Ashburn, VABuilt 2025 · S/N 10837 N12EVDaedalus LLC · Little Rock, ARBuilt 1985 · S/N 46-8508065 N12FGEchols Mill Aviation LLC · Elberton, GABuilt 1998 · S/N E-3219 N12GTNovember One Two Golf Tango LLC · Newtown, PABuilt 2016 · S/N 1438 N12LCLc Aviation LLC · Lynnfield, MABuilt 2013 · S/N 3952 N12NDCirrus Design Corp · Duluth, MNBuilt 2026 · S/N 11652 N12PFRucker Gary R · Kingman, AZBuilt 1977 · S/N 21062401 N12PTN12pt LLC · Wilmington, DEBuilt 2022 · S/N 8544 N12SBSilvano Sal · La Grange, KYBuilt 1979 · S/N 340A0911 N12TFBumblee Flight LLC · Rochester, NYBuilt 2016 · S/N 1336 N12WBOld Man Aviation LLC · Saint Louis, MOBuilt 2024 · S/N 9981 N12XYShramek Troy · Bossier City, LABuilt 2007 · S/N 42545 N12ZZUnusual Attitude LLC · Portland, ORBuilt 2014 · S/N 0728 N1303ASitehawks Aviation Inc · Jacksonville, FLS/N 3712 N1303HFire Up The Cirrus Penny LLC · Alexandria, VABuilt 2013 · S/N 3945 N130HLFair Winds Aviation LLC · Shreveport, LABuilt 1979 · S/N 414A0322 N130RACarter Distribution Lc · Salt Lake City, UTBuilt 1976 · S/N 340A0040 N130RCWilliams Brian G · Las Cruces, NMBuilt 1983 · S/N P21000822 N130RGSummit Consultants Inc · Hudson Oaks, TXBuilt 2016 · S/N 4432 N1314CDajczak Stanislaw P · Findlay, OHBuilt 2003 · S/N 0502 N131AMAmis Benjamin · Austin, TXBuilt 2007 · S/N 2865 N131DXRegistered aircraftBuilt 2020 · S/N 2059 N131EAEagle X LLC · Chamblee, GABuilt 2006 · S/N 2239 N131HFMeridian Transport LLC · Wilmington, DEBuilt 2017 · S/N 1525 N131JKJsk Aviation LLC · Little Rock, ARBuilt 2026 · S/N 11264 N131KMKeriair LLC · Point Pleasant, NJBuilt 2025 · S/N 10657 N131LTAlpha Mike Foxtrot Logistics LLC · Las Cruces, NMBuilt 2012 · S/N 0300 N131MADesert Eagle Aviation LLC · Albuquerque, NMBuilt 2001 · S/N 30-0059 N131MGHarrison Simon M · Libertyville, ILBuilt 2007 · S/N 2830 N131MKJeffrey Robert D · Chandler, AZFirst renewal noticeBuilt 2008 · S/N LS-221 N131MWFarina George · Killen, ALBuilt 2004 · S/N 41021 N131SRValiair Limited Company Trustee · Casper, WYBuilt 2006 · S/N 1887 N131TJPryor Mountain Aviation LLC · Cody, WYBuilt 2009 · S/N 3449 N131TTCharlie Kilo Enterprises Inc · Melbourne, FLBuilt 1979 · S/N U20605010 N1321CClark Charles G · Catlettsburg, KYBuilt 2006 · S/N 42517 N1322LPfendt Anton N · Spring, TXBuilt 2001 · S/N 0022 N1326CBauer George W · Windermere, FLBuilt 2020 · S/N 2140 N132BGN132bg Corp Trustee · Wilmington, DEBuilt 2005 · S/N 29-0398 N132CDLillerbug Inc · Sandy, UTBuilt 2025 · S/N 10703 N132GSukumar Goutham · Redmond, WABuilt 2022 · S/N 8913 N132JMTvpx Ars Inc Trustee · North Salt Lake, UTBuilt 2025 · S/N 10631 N132MABarry Casey B · Wichita Falls, TXBuilt 2001 · S/N 30-0060 N132MDA1 Aero Inc · Parkland, FLBuilt 2025 · S/N 10846 N132RFTom-Wolverton Matthew J · Morris Plains, NJBuilt 2002 · S/N 0298 N132RWAv8r Ranch LLC · Helena, MTBuilt 2024 · S/N 10362 N132RXJ + D Aviation Services LLC · Centerville, MAS/N 402C0609 N132TDTwin Fiddle Investment Aeronautics LLC · Atlanta, GABuilt 2025 · S/N 10896 N132WWKevoop Holdings LLC · Folsom, CABuilt 2022 · S/N 8608

Back to AD 2012-10-13