AD 81-18-04 R2

Registered aircraft · 81,733

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

N5UBWynne Brian P · Reston, VABuilt 1996 · S/N 1762N5UZRick Aviation Inc · Newport News, VABuilt 1980 · S/N 44-8107008N5VTEmaaduddin Mohammed · Yonkers, NYBuilt 1967 · S/N 28-23176N5VYFeatherstone Tony W · Denton, TXBuilt 1973 · S/N AA5-0462N5WDSonoma Valley Aircraft Inc · Vineburg, CABuilt 1980 · S/N 105DN5WKEz Air Inc · Wilmington, DES/N 30-1853N5WPPhagan Loyce W · Waterford, MIBuilt 1973 · S/N 92N5WUDiamond West LLC · Walnut Creek, CABuilt 2004 · S/N 40.400N5WWClark Nikita C · Ontario, ORBuilt 1965 · S/N 30-708N5WXCanard Aviators Inc · Novi, MIS/N 1488N5XA47 Yankee LLC · Bellaire, MIBuilt 1997 · S/N 1371N5XJOmalley Theodore J · Willow, AKBuilt 1998 · S/N 1424N5XWLewis Everett D · Comfort, TXBuilt 2004 · S/N 10242N5YPMo'S Ventures LLC · Lakeside, CABuilt 1974 · S/N 327440067N5YTKilian Jacob J · Anchorage, AKBuilt 2005 · S/N RML001N5YXRed Arrow Aviation LLC · Santa Teresa, NMBuilt 1981 · S/N 17275266N5ZMDakota & Skyy LLC · Louisville, COBuilt 1975 · S/N 0722N5ZQHigher Powered Racing LLC · Port Saint Lucie, FLBuilt 2001 · S/N 612-320-358FBN5ZURegistered aircraftBuilt 1981 · S/N 18-8109005N5ZWVinnola Bruce L · Glenrock, WYBuilt 2005 · S/N 109N60003Faucette Douglas R · Fallon, NVBuilt 1978 · S/N M-2110N60007Haynes Kevin Wayne · Pompano Beach, FLS/N MC-629N6000BYahner William P · Central Square, NYBuilt 1978 · S/N M-2108N6000PMoseley Timothy D · Calhoun, KYBuilt 1957 · S/N 23-1236N6000QInternational Air Services Inc Trustee · Carson City, NVBuilt 1965 · S/N 3221N6000TO'Neill Christopher M · Newark, OHBuilt 1973 · S/N 28-7310115N6000WPort Townsend Aero Museum · Port Townsend, WABuilt 1963 · S/N 28-20000N6000ZGillette David A · Monticello, UTBuilt 2001 · S/N 24142N6001DJohnson Scott V · Scottsdale, AZBuilt 1956 · S/N 22-4652N6001HHolmes Robert · Pittsgrove, NJBuilt 1978 · S/N MC-630N6001KAllred Warren D · Marshfield, MOBuilt 1979 · S/N WA-25N6001PZarate Roger L · La Mirada, CABuilt 1959 · S/N 24-1095N6001QCurry Gary · Everett, WABuilt 1965 · S/N 3222N6001RSorbi Aviation Inc · El Cajon, CABuilt 1978 · S/N ME-118N6001VNational Aviation Academy Of Mississippi Inc · Clearwater, FLS/N M-2112N6001YPilots Choice Aviation Equipment Leasing Co · Georgetown, TXBuilt 1978 · S/N ME-119N6002CChristiansen Aviation LLC · Wilmington, DEBuilt 1978 · S/N ME-120N6002KJet & Rotor Aviation LLC · Sacramento, CABuilt 1978 · S/N ME-122N6002LBadawi Aviation LLC · Orlando, FLBuilt 1978 · S/N ME-123N6002MDisilvestro Steven G · Wallkill, NYBuilt 1978 · S/N MC-633N6002SSouthern Adventures Inc · Stuart, FLBuilt 1979 · S/N M-2115N6002WPeppas George D Jr · Fort Wayne, INS/N 28-20002N6003CMiles Darren · Bonita Springs, FLBuilt 1979 · S/N M-2113N6003QOsborn John W · Cimarron, KSBuilt 1965 · S/N 3223N6003RRemikin I LLC · Naperville, ILS/N ME-126N6003USoarin Seven Aviation LLC · Morton, ILBuilt 1970 · S/N 28-26809N6003WCarmon Walter A · Highland, NYS/N 28-20003N6003XB&E Leasing LLC · Dubuque, IAS/N 1591N6003YAri Ben Aviator Inc · Fort Pierce, FLBuilt 1978 · S/N ME-129N6003ZPetranek John A · Mandeville, LAS/N M-2118
Back to AD 81-18-04 R2