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.

N193KCBig Blessing II LLC · Saint Louis, MOBuilt 2022 · S/N 8857 N193SRScreaming Eagle Aviation Inc · Webb City, MOBuilt 2007 · S/N 2663 N193TTBgiii Air LLC · Tampa, FLBuilt 1976 · S/N 21061601 N1942XGarrison Weldon · Texarkana, TXBuilt 1979 · S/N P21000296 N1944EHans Construction LLC · Lititz, PAS/N 340A0675 N194CDLehmar LLC · New Orleans, LABuilt 2004 · S/N 1027 N194CMPlanejohn LLC · Minnetonka, MNBuilt 2006 · S/N 1882 N194CPSkywest Aviation Inc Trustee · Albuquerque, NMBuilt 2008 · S/N 3059 N194DCA440 Holdings LLC · Brentwood, TNBuilt 2014 · S/N 0794 N194LGSunshine Sky Aviation LLC · Doral, FLBuilt 2006 · S/N 2179 N194VUphoff Jeffrey A · Roanoke, VAS/N 29-0200 N1950U3 Stones Productions LLC · Anchorage, AKBuilt 1970 · S/N 18501659 N1950XArgyll Aviation II LLC · Kiefer, OKBuilt 1998 · S/N E3174 N1951GClassic Aviation Inc · Pella, IABuilt 2003 · S/N 0630 N1952KWard & Ward Management Consultants Inc · Sparta, TNBuilt 2002 · S/N 0147 N1953UAnstrand Charles Jason · Boise, IDBuilt 1974 · S/N U20602306 N1955SNielsen Jeffrey Stephen · Ashland, ORBuilt 1995 · S/N 220 N1957CJbc 514 Capital Holdings LLC · Santa Ana, CAFirst renewal noticeBuilt 2013 · S/N 0514 N195CSTritten Aviation LLC · Weston, WIBuilt 2023 · S/N 9464 N195MBRoom For More LLC · Salt Lake City, UTBuilt 2025 · S/N 11066 N195WPWhiskey Papa Aviation LLC · Atlanta, GABuilt 2025 · S/N 10407 N1961UMccarthy Trevor William · Addison, TXBuilt 1974 · S/N U20602312 N1963EPrideaux Paul M · Henrico, VABuilt 2008 · S/N 3082 N1963MN1963m LLC · Torrance, CABuilt 2002 · S/N 0355 N1964ARex Air LLC · Madisonville, LABuilt 1993 · S/N E-2822 N1966MRomeo Whiskey LLC · Wilmington, NCBuilt 2021 · S/N 5142 N1969LBlue Skys Aviation LLC · Wilmington, DEBuilt 2004 · S/N L2K-181 N1969PPie In The Sky Aviation LLC · Eads, TNBuilt 2007 · S/N 2481 N196CAHyannis Air Service Inc DBA · Hyannis, MABuilt 1979 · S/N 402C0116 N196GXRhodes David · Washington, DCBuilt 2006 · S/N 29-0414 N196SRWhen Elephants Fly LLC · Camden, DEBuilt 2007 · S/N 2750 N1971CAndrews Aviation LLC · Columbia, MOBuilt 2024 · S/N 10363 N1973USilver Fox Aviation LLC · Bay City, MIBuilt 1974 · S/N U20602316 N1974GAirmax LLC · London, KYS/N 1297 N1975Henay Air LLC · Windermere, FLBuilt 2021 · S/N 2375 N1975PBarry Aviation LLC · Boise, IDBuilt 2022 · S/N 9016 N1978FLofty Pursuits LLC · Sacramento, CABuilt 1981 · S/N P21000711 N1978RJ Martin Auctions LLC · Waterloo, NYBuilt 2023 · S/N 9327 N1978WFlytighe LLC · Winchendon, MABuilt 2021 · S/N 5009 N197CMLester Labs LLC · Cloverdale, CABuilt 2018 · S/N 1723 N197CPN197cp LLC · Columbus, GABuilt 2008 · S/N 3056 N197CVJoseph F Gaar Jr Professional Law Corp · Lafayette, LABuilt 2016 · S/N 32-0001 N197DHHintz Donald C · Punta Gorda, FLBuilt 1997 · S/N E-3084 N197DTSzczerba Francis C · Cranberry Township, PABuilt 1997 · S/N 29-0113 N197SRLakeside Roofing And Construction LLC · Yukon, OKBuilt 2007 · S/N 2547 N1984MAnacapa Aviation LLC · Oxnard, CABuilt 2015 · S/N 4218 N1986PRegistered aircraftBuilt 2020 · S/N 2207 N1987GPhillips Michael M · Angleton, TXBuilt 1974 · S/N 414-0544 N198AZCoyote Aviation LLC · Ballston Spa, NYBuilt 1980 · S/N U20605961 N198ERCloud Dancer LLC · Santa Maria, CABuilt 1977 · S/N 21062298

Back to AD 2012-10-13