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.

N863JJMccrary Bobby C Jr · Mount Juliet, TNBuilt 2005 · S/N 22411N863MPOverlook Air LLC · Lexington, KYBuilt 2023 · S/N 30098N863PProfessional Training Aircraft LLC · Wilmington, DEBuilt 2018 · S/N 2843946N863PAUniversity Of Alaska Anchorage · Anchorage, AKBuilt 2002 · S/N 172S9062N863PTBeachy Aaron W · Whittington, ILBuilt 2018 · S/N 664N863PUTrustees Of Purdue University · West Lafayette, INBuilt 2021 · S/N 2881477N863SCPeregrine Howard Partners II Lp · New Orleans, LABuilt 2024 · S/N 2881799N863TAKeating Scott G · Ormond Beach, FLBuilt 1985 · S/N 15286026N863VLVieques Air Link · Vieques, PRBuilt 1979 · S/N 2019N863WLStadjuhar Eric J · Omaha, NES/N 863N8640CGiddens Robert F · Duncan, OKBuilt 1953 · S/N 22-1316N8640VFlannery John J · Atkinson, NES/N 816-75N8641PN8641p LLC · Gainesville, GABuilt 1964 · S/N 24-4082N8641VRusyniak Anthony J · Syracuse, NYBuilt 1975 · S/N 163-75N8642DAmerican Aviation Inc · Tracy, CABuilt 1979 · S/N 172RG0061N8642LTexas Soaring Assn · Midlothian, TXBuilt 1969 · S/N 25-5079N8642WKruckeberg Lloyd E · Amarillo, TXBuilt 1963 · S/N 28-10159N8643Gillespie Warren H · Hamilton, MTBuilt 1973 · S/N 354-73N8643DBurns Roni R · Bolivar, MOBuilt 1958 · S/N 22-5851N8643VLuvara Christopher J · Santa Clara, CABuilt 1975 · S/N 817-75N8643WJull Pamela · Bellingham, WABuilt 1963 · S/N 28-10150N8644Agaliotis Paul E · San Martin, CABuilt 1973 · S/N 918-73N8644FBemer Aviation Inc · Glastonbury, CTBuilt 1977 · S/N 770619N8644PFord Bernard C · Sidney, NYBuilt 1964 · S/N 24-4087N8644VSale Reported · Humboldt, IASale reportedBuilt 1975 · S/N 520-75N8644WMatos Noel · Newport Beach, CABuilt 1963 · S/N 28-10057N8645ECichocki Matthew R · Oviedo, FLBuilt 1976 · S/N 28-7690183N8646CFilice Gennero J · Rohnert Park, CABuilt 1953 · S/N 22-1323N8646DAdams James F · Flagstaff, AZBuilt 1958 · S/N 22-5854N8646VGautnier Mark A · Fairbanks, AKBuilt 1975 · S/N 1089-75N8647Ober John A · Candor, NYBuilt 1973 · S/N 355-73N86472Leopold Seth S · Bellevue, WABuilt 2008 · S/N 80957N8647CBrown Roger K · Port Saint Lucie, FLS/N 22-1335N8647ESkywest Leasing Inc · St George, UTBuilt 2000 · S/N 2843374N8647NVossberg Carl A · Umatilla, FLBuilt 1971 · S/N 28R-7135128N8647VSpratling Boyd M · Deeth, NVS/N 818-75N8647WChase Dan · Reno, NVS/N 28-10163N86483Eaa Aviation Foundation Inc · Oshkosh, WIBuilt 1957 · S/N 22-5777N8648CHouse Justin W · Uriah, ALBuilt 1953 · S/N 22-1326N8648PSelinger Richard · Seal Beach, CABuilt 1964 · S/N 24-4091N8648VBeachy Phil R · Bonners Ferry, IDS/N 16575N8648YChuss Edward · Metamora, MIBuilt 1969 · S/N 30-1791N8649Dudley Benjamin H · Wasilla, AKS/N 462-73N8649DGho Michael M · Fairbanks, AKBuilt 1958 · S/N 22-5857N8649NManchester Thomas P · Wilmington, DEBuilt 1971 · S/N 28-7125460N8649WHigh Desert Flyers LLC · New London, NCBuilt 1963 · S/N 28-10165N864ATCxk1 LLC · Wilmington, DEBuilt 2025 · S/N 4496622N864AUAuburn University · Auburn University, ALBuilt 2020 · S/N 172S12472N864CKTabatabai Seyed Ali · Houston, TXBuilt 2005 · S/N 172S9864N864CPCivil Air Patrol · Maxwell Afb, ALBuilt 2006 · S/N 18281854
Back to AD 81-18-04 R2