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.

N210TYRiley Charles · Littleton, COBuilt 1979 · S/N P210-00252 N210VBHoogendyk Robert · Big Bear City, CABuilt 1979 · S/N 21063776 N210VJV J Wings Inc · Wilmington, DES/N 21063387 N210VVHeesacker Stephen L Trustee · Los Altos, CABuilt 1979 · S/N 21063214 N210WCWeeks Curtis E · Cotulla, TXBuilt 1982 · S/N 21064759 N210WJRude Daniel · Leesburg, VABuilt 1982 · S/N 21064734 N210WTBarlowe James M · Enumclaw, WABuilt 1971 · S/N 21059528 N210WZHogue Tool & Machine Inc · Paso Robles, CABuilt 1973 · S/N 21060039 N210XPAnderson Andre A · El Paso, TXBuilt 1970 · S/N 21059336 N2110AWindshear Aviation LLC · Longmont, COBuilt 1977 · S/N TJ-129 N2113QGlenelg Equipment Leasing LLC · Hanover, MDBuilt 2018 · S/N 4710 N2118SAbes Erika · El Paso, TXBuilt 1975 · S/N 21061081 N211ACJames P Hill Distributor Inc · Ruston, LABuilt 2019 · S/N 4787 N211ALMallory Equipment Leasing LLC · Portland, ORBuilt 2022 · S/N 8985 N211ASBas Part Sales LLC · Greeley, COBuilt 1974 · S/N 20700259 N211AWWeis Aaron · Waban, MABuilt 2005 · S/N 1278 N211CFGoudreau Sean · Mount Dora, FLBuilt 1978 · S/N 21063013 N211CKClark Kim A · Rogers, ARBuilt 2015 · S/N 1025 N211CMMoneypit Investment Corp · Wilmington, DEBuilt 2005 · S/N 1692 N211DGSteel Crazy LLC · Page, AZFirst renewal noticeBuilt 1989 · S/N EA-489 N211FDVuelo Seguro LLC · North Logan, UTBuilt 2025 · S/N 10396 N211LR & G Schatz Farms Inc · Lockeford, CABuilt 1979 · S/N 21063183 N211LCSuddarth Steven Craig · Edgewood, NMBuilt 1974 · S/N 21060364 N211LHLidzbarski Mark A · Southington, CTBuilt 2006 · S/N 1831 N211MJKeefer Squared LLC · Rockmart, GABuilt 1994 · S/N 29-0019 N211MVClark Aviation Inc · Greenville, SCBuilt 1999 · S/N E-3244 N211PAPiedmont Air Services LLC · Helena, MTBuilt 1981 · S/N U20606415 N211PFJed Air LLC · Buena Vista, COBuilt 2022 · S/N 8721 N211RVTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2020 · S/N 2236 N211SEAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2006 · S/N 2208 N211SVMatthews Aviation LLC · Greensboro, NCS/N 340A1000 N211TMPlane Fun Inc Tr Trustee · Snellville, GAS/N 3572 N211ZNAllen Michael J · Rescue, CABuilt 1985 · S/N 24-1535 N2120XGolberg Companies Inc · Garfield, MNBuilt 1996 · S/N 29-0103 N2121SGreat Bay Aviation LLC · Spring Hill, FLBuilt 1997 · S/N 29-0106 N2122SBobo Construction LLC · Pullman, WABuilt 1975 · S/N 21061084 N21234Positive Rate LLC · Kenosha, WIBuilt 1982 · S/N 340A1207 N2126SGarnet Ridge LLC · Brooksville, FLS/N 29-0133 N212ASKff Inc · Piscataway, NJBuilt 2001 · S/N TH-1995 N212BKVitesse Aviation Holding I LLC · Englewood, NJBuilt 2009 · S/N 3558 N212DEWerre Joel F · Dunn Center, NDS/N EA-626 N212DSFlying Bee Aviation LLC · Delphi, INBuilt 2023 · S/N 9539 N212HRExport Aviation LLC · Santa Fe, NMS/N T30300239 N212KTLanier Howard W · Willis, TXS/N P206-0349 N212LLLunch Mony LLC · Fort Worth, TXBuilt 2016 · S/N 1236 N212MHM L H Properties Inc · Rogers, ARBuilt 1998 · S/N E3209 N212MMOlver Keith B · Annapolis, MDBuilt 2002 · S/N 0403 N212PPLermer Christoph · Naples, FLBuilt 1990 · S/N TH-1604 N212RNoodlebop Inc · Provincetown, MABuilt 2026 · S/N 11176 N212RRN2u Equipment Leasing LLC · Newark, DEBuilt 2021 · S/N 2357

Back to AD 2012-10-13