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.

N258PBHyannis Air Service Inc · Hyannis, MABuilt 1980 · S/N 402C0336 N258RPInternational Air Services Inc Trustee · Carson City, NVBuilt 1994 · S/N TH-1737 N258STPanchjanyam LLC · Jackson, MSBuilt 2002 · S/N 0307 N258TFHands Services Inc · Malibu, CABuilt 2011 · S/N 0231 N258WTTrigger Air LLC · Wilmington, DEBuilt 2014 · S/N 4152 N259CN259c LLC · Woodward, OKBuilt 2001 · S/N EA-684 N259CDGo Air Brokerage LLC · Wake Forest, NCBuilt 2003 · S/N 0449 N259EArboretum Aviation LLC · Fullerton, NDBuilt 2013 · S/N 0608 N259MMDavidson Bryan H · Sarasota, FLBuilt 1986 · S/N E-2311 N259PBOregon Holdings LLC · Bend, ORBuilt 2001 · S/N 0111 N259URUnbound Reflection LLC · Westlake, TXBuilt 2025 · S/N 10865 N259WTLpt Leasing LLC · Longview, TXBuilt 2019 · S/N 1996 N25AVAvalon Aviation LLC · Kennett Square, PABuilt 2020 · S/N 4966 N25BZBarbara Jean Ventures LLC · Winnsboro, SCBuilt 2021 · S/N 5103 N25CXVisair II LLC · Canton, OHBuilt 1985 · S/N 46-8508100 N25DDCirrus Air LLC · Sparks, NVBuilt 2004 · S/N 0894 N25DZCigar Army One Inc · Tampa, FLBuilt 2006 · S/N 1783 N25EBLeisurecorp Inc · Anchorage, AKBuilt 1976 · S/N 340A0043 N25FPEastern Stearman Inc Trustee · Leesburg, VABuilt 1992 · S/N E-2720 N25GPAir Data Solutions LLC · Natchitoches, LABuilt 1975 · S/N U20602889 N25HWSkimait Cirrus LLC · Kalispell, MTBuilt 2006 · S/N 2021 N25JGCenturion Aircraft Limited · Centennial, COS/N P21000329 N25LDResults Advisory LLC · Nashville, TNBuilt 2013 · S/N 0517 N25LHCole Aviation LLC · Wichita, KSBuilt 1985 · S/N 46-8508070 N25LQKpj Aviation LLC · West Palm Beach, FLBuilt 2026 · S/N 11305 N25LRRoam Airlines LLC · Eugene, ORBuilt 1981 · S/N EA-196 N25LSBzaviation LLC · Saint Louis, MOBuilt 1994 · S/N E-2838 N25MLAzalea Grove LLC · Ruston, LABuilt 2005 · S/N 1571 N25MVTeam Jet LLC · Howell, MIBuilt 2001 · S/N 0095 N25PCTacoma Arrow Plane LLC · Tacoma, WABuilt 2016 · S/N T24002122 N25QGrant Janice · Friday Harbor, WABuilt 2001 · S/N E-3398 N25RFMlf Aviation LLC · Douglasville, GABuilt 1973 · S/N 340-0307 N25SFStorage Units Capital Aviation LLC · Maitland, FLBuilt 2023 · S/N 9635 N25TAJms Properties Inc · Hudsonville, MIBuilt 1982 · S/N 340A1538 N25TEBostyancic Derek J · Grand Rapids, MNBuilt 2025 · S/N 10707 N25TMYankee Tango Mike LLC · Dublin, TXS/N EA-265 N25VLV-Jet Sr 22 Partnership LLC · Santa Monica, CABuilt 2022 · S/N 8654 N25WDSale Reported · Greeley, COSale reported, canceledBuilt 1978 · S/N P21000094 N25YTCtd Management LLC · Anderson, SCFirst renewal noticeBuilt 2017 · S/N 4456 N2600Klasson Human Capital Partners LLC · Centerville, OHBuilt 2005 · S/N 1552 N26030Lessing Aviation LLC · Denver, COBuilt 1985 · S/N 46-8508107 N260ATAston William L II · Granbury, TXBuilt 2000 · S/N 30-0046 N260AVAlpha Victor LLC · Wilmington, DEBuilt 2018 · S/N 1677 N260EABlue Sky Airfleet LLC · Kalispell, MTBuilt 2004 · S/N E-3408 N260MXValiair Lc Trustee · Casper, WYBuilt 2026 · S/N 11309 N260SRCherry Ernest M Jr · Venice, FLBuilt 2007 · S/N 2570 N2610GBas Part Sales LLC · Greeley, COBuilt 1979 · S/N 402C0064 N2611XHyannis Air Service Inc DBA · Hyannis, MABuilt 1979 · S/N 402C0072 N2613CThree Two Five Echo Fc · Corinth, TXBuilt 1985 · S/N E-2293 N2614LCharter Flights Caribbean Inc · San Juan, PRBuilt 1979 · S/N 402C0092

Back to AD 2012-10-13