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.

N158TCBoyd Brent · Fort Worth, TXBuilt 1978 · S/N TK-68 N158WCKing Air Properties LLC · Huntington Beach, CABuilt 2001 · S/N TH-2008 N1596GN1596g Inc · Peachtree City, GABuilt 1974 · S/N 340-0507 N1596TPlane Crazy Inc · Page, NDBuilt 1973 · S/N 4140376 N1598TRegistered aircraftBuilt 1981 · S/N EA-263 N159CSBank Of Utah Trustee · Salt Lake City, UTBuilt 2009 · S/N 3410 N159HAHotel Alpha II LLC · Chattanooga, TNBuilt 2005 · S/N 1459 N159SRDehbozorgi Amir · Irvine, CABuilt 2006 · S/N 2170 N159ZIdaho State University · Pocatello, IDBuilt 1978 · S/N TJ-178 N15BMTapcor Aviation LLC · Riverside, CABuilt 2008 · S/N 3300 N15CWN15cw LLC · Wilmington, DEBuilt 1983 · S/N P21000824 N15CXKlausman Branin W · Mascoutah, ILBuilt 2003 · S/N 0451 N15DDDmd Asset Management LLC · Suffolk, VABuilt 2026 · S/N 11478 N15DNSnowflake Aircraft LLC · Fayetteville, NYBuilt 1989 · S/N E-2472 N15DRTufco Flooring Delmarva Inc · N Chesterfield, VABuilt 2002 · S/N 0394 N15EUCirrus Design Corp · Duluth, MNBuilt 2026 · S/N 11379 N15GHCirrus Design Corp · Duluth, MNBuilt 2026 · S/N 11388 N15GMBristol Aviation De LLC · Wilmington, DEBuilt 1995 · S/N E2977 N15JUC&D Aviation LLC · Appleton, WIBuilt 1982 · S/N TJ-434 N15LHInternational Air Services Inc Trustee · Carson City, NVBuilt 2018 · S/N 4715 N15MLN15ml LLC · Cresskill, NJBuilt 1977 · S/N 21061780 N15MWZeezee LLC · Phoenix, AZBuilt 1978 · S/N 21063023 N15RPKnob Creek Aviation LLC · Oak Ridge, LABuilt 1974 · S/N E-539 N15RXLingo Aviation LLC · Cincinnati, OHBuilt 2004 · S/N 1164 N15SVGore Joshua · Sedro Woolley, WABuilt 1977 · S/N 340A-0226 N15TGTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2022 · S/N 8528 N15USFlypower Inc · Fort Lauderdale, FLBuilt 1975 · S/N 21060676 N15VECajunodysea Outfitters LLC · Madison, MSBuilt 2013 · S/N 3954 N15VSCirrus Design Corp · Duluth, MNBuilt 2026 · S/N 11458 N15VVLiberty Flying Club Inc Trustee · Wilmington, DEBuilt 1990 · S/N 340A1520 N15WMSidhu Teg Singh · Bakersfield, CAS/N 340A0523 N15XLrb Aviation LLC · Catawba, NCBuilt 1979 · S/N TJ-226 N15ZRN822js LLC · Norcross, GABuilt 2013 · S/N 0628 N1600XLd&B LLC · Show Low, AZS/N 21060636 N1603TMedcare Emergency Medical Services Inc · Mcallen, TXBuilt 1973 · S/N 414-0383 N1605MSelter Eric Jay Trustee · Agoura Hills, CABuilt 1977 · S/N 21061950 N160EUSkyfusion II LLC · Atlanta, GAFirst renewal noticeBuilt 2003 · S/N 0759 N160PBHyannis Air Service Inc · Hyannis, MABuilt 1981 · S/N 402C0493 N160PGYoung Jared Lee · Fitzgerald, GABuilt 2008 · S/N 2995 N160SRSarl Cirrus Marine Inc Trustee · Cheyenne, WYBuilt 2006 · S/N 2161 N1615XBvi Aviation LLC · Wilmington, DEBuilt 1975 · S/N 21060651 N1618AOne Eight Alpha LLC · Rch Palos Vrd, CABuilt 2024 · S/N 9918 N1618TRandolph James · Greensburg, PABuilt 1973 · S/N 414-0398 N161CDGreen Slip LLC · Valparaiso, INBuilt 2020 · S/N 2088 N161JKCenter Point Aviation LLC · Pensacola, FLBuilt 2007 · S/N 2462 N161JWRjss Aviation LLC · Portland, ORS/N 0762 N161RMTurbine Screws LLC · Bozeman, MTBuilt 1980 · S/N 414A0450 N161SRMcfc Inc · Hood River, ORBuilt 2006 · S/N 2120 N1620BNatrix Aviation LLC · Sagaponack, NYBuilt 2026 · S/N 11275 N1624TMelnik Charles J DBA · Omaha, NES/N 414-0404

Back to AD 2012-10-13