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.

N73477Nationwide Aviation LLC · Hudson Oaks, TXBuilt 1976 · S/N 17267493N7347DOwens Tyle M · Kenai, AKBuilt 1957 · S/N 22-5138N7347GN7347g LLC · Miami, FLBuilt 1970 · S/N 17259047N7347PVan Eyck Christopher · Cottonwood, CABuilt 1961 · S/N 24-2525N7347WHinzman Mark D · Reno, NVS/N 28-1224N73481N73481 LLC · Eaton, COBuilt 1976 · S/N 17267497N73486Begley Edward · Glasgow, KYBuilt 1976 · S/N 17267501N73487Spiess Michael Trustee · Montague, CABuilt 1976 · S/N 17267502N73489Total Flight Aircraft Leasing LLC · Apex, NCBuilt 1976 · S/N 17267503N7348BPatry Andrew · El Mirage, AZBuilt 1977 · S/N A1520753N7348GHardy James H · Albany, NYBuilt 1970 · S/N 17259048N7348JDippolito Mario M · Sherwood, ARBuilt 1968 · S/N 28-24698N7348LMcmahan Harley B · Gakona, AKBuilt 1975 · S/N 18-7509050N7348PSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1961 · S/N 24-2526N7348WRosenau Dillon L · Upham, NDBuilt 1963 · S/N 28-1226N7348XShielded Holdings LLC - Series Av 11 · Katy, TXBuilt 1977 · S/N R18200083N7348ZPittsburgh Soaring Association · Pittsburgh, PABuilt 1965 · S/N 25-3299N7349814a Flying Club Inc · Mooresville, NCBuilt 1976 · S/N 17267508N7349BWilliams Kiplin S · Midland, NCBuilt 1977 · S/N A1520754N7349JWolfe Frank A · Nahcotta, WABuilt 1968 · S/N 28-24699N7349KWimberly Fred N · Callao, VABuilt 1950 · S/N 20-256N7349PMathison John M · Vancouver, WABuilt 1961 · S/N 24-2527N7349WGritzo Russell E · Edgewood, NMBuilt 1963 · S/N 28-1228N734AEFlight Club 502 Inc · Louisville, KYBuilt 1977 · S/N 17268696N734AHAnderson Zachary Q · Rudyard, MTBuilt 1977 · S/N 17268699N734AMGlobal Flight Training Solutions Inc · Immokalee, FLBuilt 1977 · S/N 17268703N734AQBarrans Daniel L · Glenmoore, PABuilt 1977 · S/N 17268705N734ASStory Larry W · Double Oak, TXBuilt 1977 · S/N 17268707N734AULeading Edge Aviation Inc · Doylestown, PABuilt 1977 · S/N 17268709N734AXPenel Aviation Corp · Baldwin, NYBuilt 1977 · S/N 17268712N734AYRico Aviation Services Inc · Miami, FLBuilt 1977 · S/N 17268713N734BBLeading Edge Flight Academy LLC · Bend, ORBuilt 1977 · S/N 17268716N734BFMortensen Jonathan J · Grovetown, GABuilt 1977 · S/N 17268720N734BGVancina Simon J · New Lenox, ILBuilt 1977 · S/N 17268721N734BHMy Way Aviation LLC · Weston, FLBuilt 1977 · S/N 17268722N734BNAlameda Aero Club · Alameda, CABuilt 1977 · S/N 17268727N734BQTri State Aviation Inc · Wahpeton, NDS/N 17268729N734BTSorbi Aviation Inc · El Cajon, CABuilt 1977 · S/N 17268732N734BUAirplanes And Attitude LLC · Mckinney, TXBuilt 1977 · S/N 17268733N734BVTurner Richard D · Panama City, FLS/N 17268734N734BWSuperior Aviation Gateway LLC · Tampa, FLBuilt 1977 · S/N 17268735N734BXGreene Travis Charles · Acworth, GABuilt 1977 · S/N 17268736N734BZBurleson Cameron Reynolds · Oak Island, NCBuilt 1977 · S/N 17268738N734CACobb Brian A · Destin, FLBuilt 2008 · S/N 71088N734CCFranks Janice G · Eagleville, TNBuilt 1977 · S/N 17268741N734CFRivertown Flying Partnership · Marine On St Croix, MNBuilt 1977 · S/N 17268744N734CHC & R Aircraft Llp · Perry Hall, MDBuilt 1977 · S/N 17268746N734CJWings Over Texas Holdings LLC · Denton, TXBuilt 1977 · S/N 17268747N734CLStates Construction Company · Indianola, IABuilt 1977 · S/N 17268749N734CP5280 Flying Club LLC · Castle Pines, COBuilt 1977 · S/N 17268752
Back to AD 81-18-04 R2