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.

N7260WO'Day John E · Rindge, NHBuilt 1963 · S/N 28-1092N7260YDeuce Aire LLC · Middletown, DEBuilt 1964 · S/N 30-294N72614Liberty Leasing IV LLC · Melbourne, FLBuilt 2000 · S/N 20608117N7261GKindblade Aeronautics LLC · Casper, WYBuilt 1970 · S/N 17258961N7261MCox Jeff C · Newark, OHBuilt 2000 · S/N 18280901N7261PHolleman William James · Simpsonville, SCBuilt 1961 · S/N 24-2437N7261QSchilling Aviation Services LLC · Salina, KSS/N 17260561N7261WKurywchak Daniel A · Cameron Park, CABuilt 1963 · S/N 28-1093N7261YKocak Robert G Jr · Peoria, AZBuilt 1964 · S/N 30-295N7261ZChristiansen Aviation LLC · Wilmington, DEBuilt 2002 · S/N 172S9080N7262FParlee Chad E · Lakeport, CABuilt 1968 · S/N 28-25181N7262JKemp Lyman E · Ketchikan, AKBuilt 1968 · S/N 28-24584N7262MRegistered aircraftBuilt 2000 · S/N 18280900N7262PParker Dennis Scott · Lubbock, TXBuilt 1961 · S/N 24-2438N7262QFlikins Barbara L · Fillmore, CABuilt 1972 · S/N 17260562N7262WDube Colin T · Minot, MEBuilt 1963 · S/N 28-1095N72639Dischler Stephen · New Lisbon, WIBuilt 1999 · S/N 17280806N7263GHardy Chad A · Rush City, MNBuilt 1970 · S/N 17258963N7263JKl Aviation LLC · Catawba, NCBuilt 1968 · S/N 28-24548N7263PHoffman Raymond F · Encinitas, CABuilt 1960 · S/N 24-2439N7263QWyatt Barbara Louise · Cheyenne, WYBuilt 1972 · S/N 17260563N7263WKontour Shawn K · Wheatland, WYBuilt 1963 · S/N 28-1096N7263YRag Wings And Radials Aircraft Leasing LLC · Georgetown, DEBuilt 1964 · S/N 30-298N7263ZAnderson Daniel A · Overly, NDBuilt 1965 · S/N 25-3200N72647Awa Tupua LLC · Brambleton, VABuilt 1999 · S/N 18280623N7264DGravity & Grace LLC · Mill Valley, CABuilt 1999 · S/N 20608062N7264FPodyaire LLC · Ruston, LAS/N 28-25184N7264JHoseney Richard W Jr · Como, MSBuilt 1968 · S/N 28-24532N7264LLarson Aircraft LLC · Sandy, UTBuilt 1972 · S/N AA1A-0464N7264QAdams Rick B · Ashford, WABuilt 1972 · S/N 17260564N7264WFehringer John T · Sidney, NES/N 28-1097N7264YYogi Air LLC · Wadsworth, OHBuilt 1964 · S/N 30-299N72650Mecham Gerald W Jr · Mesa, AZBuilt 1946 · S/N 9826N72653Atp Aircraft 2 LLC · Wilmington, DEBuilt 1999 · S/N 17280807N72658Tidewater Flying Club Inc · Newport News, VABuilt 1999 · S/N 18280643N7265BHolladay Aviation LLC · Jacksonville, FLBuilt 1999 · S/N 17280749N7265FShouling & Philip Enterprise · Lancaster, CAS/N 28-25185N7265JSwoboda Charles · Anchorage, AKBuilt 1968 · S/N 28-24528N7265KSale Reported · Phoenix, AZSale reported, canceledBuilt 1950 · S/N 18-158N7265LGulfstream Aerospace Corp · Savannah, GABuilt 1972 · S/N AA1A-0465N7265PQuinlan John H · Claxton, GABuilt 1961 · S/N 24-2441N7265WSayles Michael A · Shorewood, ILBuilt 1963 · S/N 28-1098N7265ZAtp Aircraft 2 LLC · Wilmington, DEBuilt 1999 · S/N 17280769N72662Jwa Flight School LLC · Bolingbrook, ILBuilt 1999 · S/N 17280817N72664Advanced Aviation Group LLC · Frederick, MDBuilt 1999 · S/N 17280818N72667Rro Leasing LLC · Grand Forks, NDBuilt 1999 · S/N 18280652N72669Mid-Island Air Service Inc · Ronkonkoma, NYBuilt 1999 · S/N 18280496N7266DMelbourne Flight Training LLC · Melbourne, FLBuilt 1979 · S/N 17272912N7266JPaolo Keath R · Carlton, ORBuilt 1968 · S/N 28-24520N7266MFerrarer Joseph H Trustee · Glendora, CABuilt 1999 · S/N 18280619
Back to AD 81-18-04 R2