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.

N26514Hyannis Air Service Inc · Hyannis, MABuilt 1980 · S/N 402C0344 N2651SHyannis Air Service Inc · Hyannis, MABuilt 1980 · S/N 402C0342 N2653M97 Lima LLC · Edina, MNBuilt 1986 · S/N E-2315 N2656SPierini William C · Chico, CABuilt 1976 · S/N 21061346 N2658ZVirtue Genetics LLC · Cedar Rapids, IAS/N 421C0827 N2659BAnderson Brian E · York, PABuilt 2002 · S/N 0237 N2659UMec Management LLC · Wilmington, DEBuilt 1986 · S/N E-2316 N265ASCapital Holdings 221 LLC · Newark, DEBuilt 2021 · S/N 2425 N265CESeven Out Aviation LLC · Rio Verde, AZBuilt 2023 · S/N 9452 N265JCTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2020 · S/N 2092 N265JKArchiekilo Aviation LLC · Houston, TXBuilt 2024 · S/N 10177 N265JPN265jp LLC · Mill Valley, CABuilt 2004 · S/N 0888 N265KGCavu 1989 LLC · New Hope, PABuilt 2024 · S/N 10160 N265KJCirrus Sr22t 2307 Inc Trustee · Wilmington, DEBuilt 2021 · S/N 2307 N265MBFlying Brick LLC · Monroe, NCBuilt 2024 · S/N 10163 N265PCSilver Eagle II LLC · Carson City, NVBuilt 1980 · S/N 340A-0996 N265SBCs Aero LLC · Nassau, DEBuilt 2016 · S/N 1462 N265TGRegistration Pending · Darnestown, MDRegistration pendingBuilt 2022 · S/N 8940 N2664Lcj Holdings LLC · Youngsville, LAS/N 310R0195 N2664FWisconsin Aviation Inc · Watertown, WIBuilt 1980 · S/N 414A0534 N2664LAce Airways LLC · Quincy, WABuilt 1980 · S/N 414A0535 N2664MInfcon LLC · Wilmington, DEFirst renewal noticeS/N E-2317 N2669NWilliamson Benjamin J · Morgan Hill, CABuilt 1979 · S/N 340A0735 N266KPN266kp LLC · Cincinnati, OHBuilt 2023 · S/N 9386 N266SRRf Aviation LLC · Eaton, COBuilt 2007 · S/N 2626 N266UKAltitude Assets LLC · Palo Alto, CABuilt 2025 · S/N 10491 N2673BM & N Of Alabama LLC · Magnolia Springs, ALBuilt 1980 · S/N 414A0630 N2673DAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1979 · S/N 340A0755 N2673SWilliams Randall S · Chico, CABuilt 1976 · S/N 21061348 N2676BKero Jet Corporation · Montgomery, TXBuilt 1979 · S/N 340A0762 N2676RStauter Michael D · Idabel, OKBuilt 1979 · S/N 340A0765 N2676YHands Holdings · Newark, DEBuilt 1981 · S/N 414A0631 N267CAHyannis Air Service Inc DBA · Hyannis, MABuilt 1979 · S/N 402C0030 N267CPVanesian Bryan Dean · Apple Valley, CABuilt 2008 · S/N 3047 N267HHSankaran Mahesh · Amherst, NYBuilt 2014 · S/N 0878 N267LMAviation Trust Co LLC Trustee · Oklahoma City, OKBuilt 1979 · S/N P21000362 N267PJune26 Investments LLC · Pinehurst, NCBuilt 2026 · S/N 11302 N267PKRegistration Pending · Summerville, GARegistration pendingBuilt 2014 · S/N 4156 N267WTTaylor Mark T · Walnutport, PABuilt 2019 · S/N 2019 N2688DB2 Air LLC · Pierre, SDBuilt 1979 · S/N 414A0332 N2688MAlcyone Trust Corp Trustee · Wichita, KSBuilt 1979 · S/N 414A0334 N2688XDw Hamm Consulting LLC · Malibu, CABuilt 1979 · S/N 414A0336 N2689DRegistration Pending · Greenwood, MSRegistration pendingS/N 414A0401 N2689GShandog Air LLC · Ashland, KYBuilt 1979 · S/N 414A0402 N2689JFinley Taylor J · Colby, KSBuilt 1979 · S/N T18803497T N268CDKahng Jim · Torrance, CABuilt 2003 · S/N 0436 N268SRCirrus Design Corp · Duluth, MNBuilt 2007 · S/N 2334 N268WGolf Links Inc · Hermitage, TNBuilt 2006 · S/N 42542 N2690JDodson International Parts Inc · Rantoul, KSBuilt 1979 · S/N T18803498T N2690TN633at LLC · Punta Gorda, FLS/N 414A0408

Back to AD 2012-10-13