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.

N8573XSale Reported · North Royalton, OHSale reportedBuilt 1981 · S/N 38-81A0095N8574CVan Wagner Aerial Media LLC · Hollywood, FLBuilt 1953 · S/N 18-2728N8574KSkyborne Airline Academy Inc · Vero Beach, FLBuilt 2015 · S/N 2842409N8575BMilam Michael S · Robinson, TXBuilt 2020 · S/N 3RX159N8575VMcintyre Jon D · Fairbanks, AKBuilt 1975 · S/N 142-75N8575WSkyborne Airline Academy Inc · Vero Beach, FLBuilt 2015 · S/N 2842410N8576CReser Byron G · Walla Walla, WABuilt 1953 · S/N 18-2730N8576VJam Three LLC · St George, UTBuilt 1974 · S/N 498-75N8576WHaynes Edward · Snohomish, WABuilt 1963 · S/N 28-10088N8576XSkyborne Airline Academy Inc · Vero Beach, FLBuilt 2015 · S/N 2842411N8576YCenterline Holdings LLC · Belgrade, MTS/N 18-8889N8577Burke Jeremy D · Westminster, COBuilt 1964 · S/N 2737N8577CWaldmiller Robert Joseph · Rosamond, CABuilt 1976 · S/N 32-7740001N8577VHoran Spraying LLC · Plainview, TXBuilt 1974 · S/N 309-75N8577WM97west LLC · Fargo, NDBuilt 1963 · S/N 28-10089N8577YSkyborne Airline Academy Inc · Vero Beach, FLBuilt 2015 · S/N 2842412N8578Ray Christopher Kevin · Wake Forest, NCBuilt 1973 · S/N 915-73N8578CRiver Valley Flyers LLC · West Hartford, CTBuilt 1976 · S/N 28-7690152N8578DCoy Shane A · Nenana, AKBuilt 1958 · S/N 18-6236N8578EDamrow L Bruce · Jay Em, WYBuilt 1959 · S/N 7GC-132N8578VNelson Timothy E · Fairbanks, AKBuilt 1974 · S/N 143-75N8578ZSkyborne Airline Academy Inc · Vero Beach, FLBuilt 2015 · S/N 2842413N8579Ralls Eddie · Evergreen, ALBuilt 1973 · S/N 457-73N8579CSolberg John W · Bismarck, NDBuilt 1953 · S/N 18-2732N8579NWillaero LLC · Union City, TNBuilt 1971 · S/N 28-7105133N8579PWor LLC · Jamaica Beach, TXBuilt 1964 · S/N 24-4036N8579VWalsh Leo A Jr · Anchorage, AKBuilt 1974 · S/N 797-75N8579WWessler George H · Dunedin, FLBuilt 1963 · S/N 28-10091N857ACToedtli Bryan S · Vancouver, WAS/N 7AC-2520N857AKOld City Helicopter Sales LLC · St Augustine, FLS/N 1145N857AUAuburn University · Auburn, ALBuilt 2018 · S/N 172S12126N857DKKnight Kevin · Dallas, TXBuilt 1983 · S/N R18201935N857ERAlpha International Aircraft Inc · Lewes, DES/N 15282420N857GArcher Flight LLC · Wilmington, DEBuilt 2018 · S/N 2881068N857JWWarren Joseph A · Milford, DEBuilt 1963 · S/N 2435N857MMVigilante Helicopters LLC · Lewistown, MTBuilt 1982 · S/N 723N857NTSmeltz Kent · Dornsife, PABuilt 2018 · S/N 18283059N857PDFelter John Vincent Jr · Lago Vista, TXFirst renewal noticeBuilt 2000 · S/N 18280857N857RDUniversity Of North Dakota · Grand Forks, NDBuilt 2025 · S/N 30109N857SSjs Aviation Co · Casper, WYBuilt 1981 · S/N 28-8190224N857SCFf22 LLC · Scottsdale, AZBuilt 2024 · S/N 2881741N857SPSoutheastern Oklahoma State University · Durant, OKS/N 172S8115N8580DKedrowski James L · Wasilla, AKBuilt 1958 · S/N 18-6238N8580ESkyborne Airline Academy Inc · Vero Beach, FLBuilt 2015 · S/N 2842414N8580NA1 Aviation LLC · Lewis, DEBuilt 1969 · S/N 28-11317N8581ASkyborne Airline Academy Inc · Vero Beach, FLBuilt 2024 · S/N 28020159N8581DDutch Air LLC · Kalispell, MTBuilt 1957 · S/N 18-6239N8581JSkyborne Airline Academy Inc · Vero Beach, FLBuilt 2015 · S/N 2842415N8581VObx Airplanes LLC · Manteo, NCBuilt 1975 · S/N 805-75N8582CCurran Aviation Services LLC · Yorba Linda, CABuilt 1976 · S/N 28R-7635166
Back to AD 81-18-04 R2