OpenAirDocs.org
AD 47-40-02

Registered aircraft · 5,088

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
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:47-40-02')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:47-40-02')
  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.

N1002EMccurdy James R · Hampden, MEBuilt 1946 · S/N 7AC-4552N1003KScott Michelle · Vallejo, CABuilt 1946 · S/N 3730N100ZYWalden Taylor G · Pueblo, COBuilt 2016 · S/N ONEN1012Papon Bruce · Hardtner, KSBuilt 1947 · S/N 11BC-106N10149Price John · Bennington, KSS/N P-510N10169Mccroskey Danny D · Ward, ARS/N 101N10188Maggio Rocco M · Waupaca, WIBuilt 1947 · S/N 7BCM-4N101GRAlshamari Ahmad M · San Mateo, CABuilt 1946 · S/N 9749N101RKettunen Alan C · Ashtabula, OHBuilt 1946 · S/N 2125N1026ELampros James C · Salem, ORBuilt 1946 · S/N 7AC-4577N102ZXJurado Lance M · Ocklawaha, FLBuilt 2008 · S/N 1101N1032EDannecker Christopher T · Lake City, FLBuilt 1946 · S/N 7AC-4583N1033BRudd Wayne G · Basalt, COBuilt 1979 · S/N 1N103WEEngel Douglas A · Plainfield, ILS/N 2537N10450Grantham George F · Covington, LABuilt 1947 · S/N 7BCM-97N10456Registered aircraftBuilt 1956 · S/N 7BCM-432N10493Jarnagin William E · Brandon, FLBuilt 1956 · S/N 7BCM341N104BKnl Associates LLC · Mansfield, OHBuilt 1946 · S/N 2533N104GMRegistered aircraftBuilt 1999 · S/N 1036N10500Brauer Michael V · Ozark, ALBuilt 1956 · S/N 47-1183N10504Short David · Warrensburg, MOBuilt 1956 · S/N 47-1120N10508Loffert George U Jr · Killeen, TXS/N 7DC-502N1050KLynden Aeronautical Services LLC · Lynden, WABuilt 1946 · S/N 3777N10516Ness David · Minneapolis, MNBuilt 1981 · S/N 1N10520Eiteuner Mark P · Saint Helen, MIBuilt 1947 · S/N 47-1106N10525C&L Aviation LLC · London, WIBuilt 1948 · S/N 48-464N1057NMiller Richard L · Erie, COBuilt 1982 · S/N 122N1059EDeaero LLC · Darwin, MNS/N 7AC-4610N1064KStein Andrew · Modesto, CABuilt 1946 · S/N 3791N106FBZimmerman Frederick J · Boulder City, NVBuilt 2010 · S/N 001N1078KClairday Preston H · Melbourne, ARS/N 3805N10866Mcglothlen Mike C · Muscatine, IABuilt 1975 · S/N JE-2N1088ESmith Mark E · Lakeville, NYS/N 7AC-4641N108RHBashaw Nathan R · Salem, NYBuilt 1940 · S/N 5958N10967Weeks Kermit A · Polk City, FLBuilt 1931 · S/N 1145N1096EMarrs David R DBA · Bella Vista, ARBuilt 1946 · S/N 7AC-4649N10982Burris Kye A · Gillett, ARBuilt 1972 · S/N 41-72N10ANSouth Dakota Hist Avn Preservation & Educ Soc Inc · Canistota, SDBuilt 1947 · S/N 7BCM-445N10KSMorris Jerry M · Summerville, SCBuilt 1946 · S/N 388N10MJHocker James L · Brookville, OHBuilt 1988 · S/N 1104N1109BWeymouth James H · Jackson, MIBuilt 1947 · S/N 5736N110QSilvaire Air LLC · Gun Barrel City, TXBuilt 1948 · S/N 5983N110RHHardin Donald D Trustee · Kirkwood, MOBuilt 1999 · S/N 766N110RRGalloway Landings LLC · Caledonia, MIBuilt 1946 · S/N 19659N110XPlayter Bud W DBA · Gowen, MIBuilt 1946 · S/N 10449N1114BGiddens Ronald E · Boynton Beach, FLS/N 5741N1115BBradley Lawrence A · Lafayette, CAS/N 5742N1116Lauer Michael J · Kerrville, TXBuilt 1947 · S/N 7BCM-282N1118BFraser Christopher D · Gig Harbor, WABuilt 1947 · S/N 5745N111BGehrlein Rodney L · Waterford, PABuilt 1961 · S/N B-1
Back to AD 47-40-02