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.

N7565VRehwald William J S · Santa Monica, CAS/N 177RG0856N7565WHurdle Scott R · Clemmons, NCBuilt 1963 · S/N 28-1506N7565XDonaldson Bros Flying Circus LLC · Spencer, IABuilt 1977 · S/N R18200103N7565YVictor Robert W Jr · Topeka, KSBuilt 1964 · S/N 30-629N7566KHorseshoe Bar Land & Livestock LLC · Gillette, WYBuilt 1950 · S/N 18-283N7566PLambert Dwight E · Albany, ORBuilt 1961 · S/N 24-2777N7566RHill Bruce W · Newton, ILBuilt 1966 · S/N 28-22130N7566WStrobel Gary D · Mooresville, NCBuilt 1964 · S/N 28-1507N7566YS & D Adventure LLC · Middletown, DEBuilt 1964 · S/N 30-630N7567FMansfield Heliflight Inc · Milton, VTS/N 234-70N7567GWhipple Eugene B · Mchenry, ILBuilt 1970 · S/N 17259267N7567HGuidici Aidan G · San Antonio, TXS/N 12-437N7567JFidelis Universal Technology Inc · Chino Hills, CABuilt 1968 · S/N 28R-30946N7567PSteigerwalt Jeffrey A · Lehighton, PABuilt 1961 · S/N 24-2778N7567RThomas Baley B · Zavalla, TXFirst renewal noticeBuilt 1966 · S/N 28-22131N7568FTranbarger Tad E · Macksville, KSBuilt 1969 · S/N 229-70N7568JRoberts Donald B · Albion, ILBuilt 1968 · S/N 28R-30947N7568PBroussard James · Colmesneil, TXBuilt 1961 · S/N 24-2779N7568TSale Reported · Phoenix, AZSale reportedBuilt 1977 · S/N R18200039N7568VPawlish Andrew M · Fort Collins, COBuilt 1976 · S/N 177RG0859N7568YAviation Associates LLC · Oxford, MDBuilt 1977 · S/N R18200137N7569DThiele Tamara L · Anchorage, AKBuilt 1957 · S/N 18-5854N7569FMainero Tanner R · Chehalis, WABuilt 1969 · S/N 731-70N7569GAirborne LLC · Wilmington, DEBuilt 1970 · S/N 17259269N7569HCompton Steven · East Northport, NYBuilt 1946 · S/N 12-439N7569PBrowne Donald K · Labelle, FLBuilt 1961 · S/N 24-2780N7569VLiberty Capital LLC · Kalispell, MTBuilt 1976 · S/N 177RG0860N756AAtp Aircraft 6 LLC · Wilmington, DEBuilt 2007 · S/N 4496244N756ALLange Robert Brandt · Newport Beach, CABuilt 1979 · S/N R18201023N756AWLincoln Skyways Inc · Lincoln, CABuilt 1976 · S/N 17267877N756BCBuchanan Bryan DBA · Gig Harbor, WABuilt 1979 · S/N R18201028N756CCBrown Travis J · Lincoln, ALS/N R18201035N756CKMckee Jay Russell · Baggs, WYBuilt 1979 · S/N R18201038N756CXCahill Brian H · Valley Center, CABuilt 1979 · S/N R18201042N756DFFroster David C · Ravenna, MIBuilt 2021 · S/N 60330N756EBTak Holdings LLC · Pleasant View, TNBuilt 1979 · S/N R18201046N756EFTim Daniels Inc · Labelle, FLBuilt 1979 · S/N R18201048N756EMPacific Aircraft Management LLC · Tacoma, WABuilt 1979 · S/N R18201052N756EUFisher Air LLC · Cardington, OHBuilt 1979 · S/N R18201055N756EVOyarzo Benjamin C · Cascade, IDBuilt 1979 · S/N R18201056N756EZBear Branch Hedeen LLC · Meridian, IDBuilt 1979 · S/N R18201058N756FCSunny Aviation Investments Inc · San Francisco, CABuilt 1979 · S/N R18201059N756GAtp Aircraft 9 LLC · Wilmington, DEBuilt 2021 · S/N 2881462N756GEAbraham Curtis L · Byron, WYBuilt 1979 · S/N R18201071N756GLLawrence Cyril Leonard · Merced, CABuilt 1979 · S/N R18201073N756GYLake Superior College · Duluth, MNBuilt 1979 · S/N R18201074N756GZGlasow Zachary · Klamath Falls, ORBuilt 1979 · S/N R18201075N756JBRocky Mountain Great Planes LLC · Loveland, COBuilt 1979 · S/N R18201080N756JLN756jl LLC · Virginia Beach, VABuilt 1979 · S/N R18201082N756JPHjs Aviation LLC · Fort Collins, COBuilt 1979 · S/N R18201083
Back to AD 81-18-04 R2