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.

N232KASciathain Holdings LLC · Newark, DEBuilt 2021 · S/N 2389 N232MCCirrus Design Corp · Duluth, MNBuilt 2026 · S/N 11223 N232MMBuilder Tony Hirst LLC · Kittrell, NCBuilt 2006 · S/N 2302 N232SRRegistration Pending · Vandalia, OHRegistration pendingBuilt 2006 · S/N 1990 N232WHCool Beenz LLC · Fort Myers, FLBuilt 2019 · S/N 1989 N232WVLewis And Clark Adventures LLC · Lewes, DEBuilt 1994 · S/N E-2906 N2330JWilliamsburg Air Service Inc · Kingstree, SCBuilt 1979 · S/N T18803455T N2332JDon M Barron Contractor Inc · Farmerville, LABuilt 1999 · S/N E-3262 N2333BN2333b LLC · Oklahoma City, OKBuilt 1997 · S/N TH-1833 N2333VTytan Holdings LLC · Kalispell, MTBuilt 1998 · S/N E-3183 N2334WBlazek James T · Malta, ILBuilt 1997 · S/N E-3134 N2335KBflyin LLC · Scottsdale, AZBuilt 1997 · S/N E-3135 N2335RPropellerhead Aviation LLC · Santa Cruz, CABuilt 1997 · S/N TH-1835 N2336MHerd James L · Gardnerville, NVBuilt 1997 · S/N E-3136 N2337TPate Jason L · Bedford, TXBuilt 1997 · S/N E-3137 N233ABWma Aviation LLC · Harrisonville, MOBuilt 2023 · S/N 9423 N233CWHeiser Equipment Rental LLC · Lees Summit, MOBuilt 2020 · S/N 2218 N233FDWings Of Justice LLC · Wilmington, NCBuilt 2025 · S/N 10400 N233GKGoodwin Joseph N · Grass Valley, CABuilt 1968 · S/N D-8777 N233JHAircraft Holding Solutions LLC Trustee · Newark, DEBuilt 1977 · S/N 414A0009 N233LSSelznick Larry Trustee · Stevenson Ranch, CABuilt 2004 · S/N 0885 N233MMHigh Way LLC · Wilmington, DEBuilt 2017 · S/N 4445 N233NCEnergyview LLC · Tioga, NDBuilt 2012 · S/N 3905 N233RGScouts Honor Aviation LLC · Allen, TXBuilt 2014 · S/N 0934 N233RHDch Aviation LLC · Scottsdale, AZBuilt 2026 · S/N 11369 N233RVReeve Carole A · Anchorage, AKBuilt 2007 · S/N L2K-233 N233SBC2c LLC · Hamilton, MTBuilt 2002 · S/N 0242 N233SROharra Robert J · Buckley, WAS/N 2185 N233WZInduction Aviation LLC · Lewes, DEBuilt 2006 · S/N 1752 N2340APommersheim John Mark · Dulles, VAS/N E-3182 N2340UTex-Pan Aviation Inc · Amarillo, TXBuilt 1982 · S/N 21064779 N2342HLakes Treatment Center Inc · Angels Camp, CABuilt 1998 · S/N EA-621 N2343VWischmeyer Jason B Md · Lubbock, TXBuilt 1998 · S/N EA-616 N2345WHanisch Paul J · Crosby, NDBuilt 1998 · S/N E-3188 N2347GSmith Steven L · Whitehall, MTBuilt 1998 · S/N TH-1867 N2347VSomes Jason S · Santa Rosa Valley, CABuilt 1998 · S/N E-3147 N2348QLegha Jaskirat · Holly Ridge, NCBuilt 1998 · S/N TH-1848 N234AFFanswoop LLC · Cincinnati, OHBuilt 2016 · S/N 1321 N234AKKihneman David J · Spring, TXBuilt 2007 · S/N 2878 N234BJJmc Commercial Contractors LLC · Porter, TXBuilt 2007 · S/N 2541 N234BWWaring Marvin Barton · Anacortes, WABuilt 1979 · S/N P21000290 N234CL40 Richmond LLC · Pittsfield, MABuilt 2010 · S/N 0050 N234CROcf Air LLC · Phoenix, AZBuilt 2010 · S/N 0016 N234CSCirrus Design Corp · Duluth, MNBuilt 2026 · S/N 11639 N234CWWright Caleb · Douglas, GABuilt 2015 · S/N 4261 N234CZBank Of Utah Trustee · Salt Lake City, UTBuilt 2007 · S/N 2548 N234DPConnect 4 Ventures LLC · Woodberry Forest, VABuilt 2024 · S/N 10214 N234E234 E Aviation LLC · Branford, CTBuilt 2023 · S/N 9074 N234ETAir Fergie LLC · Camden, DEBuilt 2026 · S/N 11257 N234FS234fs LLC · Ponte Vedra Beach, FLBuilt 1955 · S/N 53-4132

Back to AD 2012-10-13