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.

N78928Lejcar Matthew J · Cumberland Furnace, TNBuilt 1961 · S/N 1962N78929Boccaccio Peter A · Burke, SDS/N 1963N7892VLambert Mathew Chase · Chapel Hill, TNBuilt 1964 · S/N 2854N7892WRegistered aircraftBuilt 1964 · S/N 28-1917N7892YHarrison Richard J · South Hamilton, MABuilt 1966 · S/N 30-979N78930Klingenberg Richard A · Idaho Falls, IDBuilt 1961 · S/N 1964N78934Harville Leonard W · Giddings, TXBuilt 1961 · S/N 1968N78936Napier James C · San Diego, CABuilt 1962 · S/N 1970N78937Reisen LLC · Stevensville, MTBuilt 1961 · S/N 1971N78938Wings Over Texas Holdings LLC · Denton, TXBuilt 1968 · S/N 17257794N7893DMoes John E · Manchester, IABuilt 1957 · S/N 22-5516N7893GRegistration Pending · Bucyrus, OHRegistration pendingBuilt 1970 · S/N 17259593N7893PBas Part Sales LLC · Greeley, COS/N 24-3122N7893VDarnell Noah Alexander · Searcy, ARBuilt 1964 · S/N 2855N7893YRegistered aircraftBuilt 1966 · S/N 30-980N78940Gaskins Gregory G · Godley, TXS/N 1974N78943Tutino John · Pleasant Valley, NYBuilt 1961 · S/N 1977N78945Ag-Aero Services LLC · Spring Hill, FLBuilt 1962 · S/N 1979N78946Terra Magic LLC · St Anthony, IDS/N 1980N78949Tour Talent LLC · Akron, OHFirst renewal noticeBuilt 1961 · S/N 1983N7894CAllen Rob · Lancaster, OHBuilt 1975 · S/N 28-7615066N7894GAr Aero Services LLC · Sacramento, CABuilt 1970 · S/N 17259594N7894PBayorek Barry E · West Wendover, NVBuilt 1962 · S/N 18-7876N7894VHydock David B · Leslie, ARBuilt 1965 · S/N 2937N7894WWiley Thomas W · Anchorage, AKBuilt 1964 · S/N 28-1921N7895Matukaitis William K · Millbury, MABuilt 1968 · S/N 123N78953Holman Richard S · Clearmont, MOBuilt 1961 · S/N 1987N78955Stuber Paul A · Kansas City, MOBuilt 1961 · S/N 1989N78956Pauly Traviston · Natrona Heights, PABuilt 1961 · S/N 1990N78959Nelson Brian · Pennsburg, PABuilt 1961 · S/N 1993N7895HRoman Brooke · Talkeetna, AKBuilt 1946 · S/N 12-799N7895SOcean Aerial Ads Inc · Berlin, MDFirst renewal noticeBuilt 1976 · S/N 586-76N7895VCleared For Takeoff LLC · Katonah, NYBuilt 1976 · S/N 177RG0913N78960Lydon Ethan J · Lumberton, NJBuilt 1961 · S/N 1994N78961Schuster Christopher J · Sherman, TXBuilt 1961 · S/N 1995N78962Smith Eric A · Kelso, WAS/N 1996N78965Clore Gregory N · Ashland City, TNBuilt 1961 · S/N 1999N78968Harris Rex D · Mason City, IABuilt 1962 · S/N 2142N7896DJohnson Rickie G · Callahan, FLBuilt 1957 · S/N 22-5522N7896HKiser Gerald S · Christiana, TNBuilt 1946 · S/N 12-798N78972Quimby Dean Kelly · Lino Lakes, MNS/N 2006N78975Johnson William P · Shreveport, LABuilt 1962 · S/N 2009N78978Martin Gary P · Boonville, MOBuilt 1968 · S/N 17257796N7897WDimario Carmen · Wilmington, DEBuilt 1964 · S/N 28-1925N78982Douglass William W III · Panora, IABuilt 1962 · S/N 2016N78983Richard Kroll A Law Corp · Laguna Niguel, CABuilt 1962 · S/N 2017N78984Goodin Charles R Jr · Chillicothe, OHBuilt 1962 · S/N 2018N78987Sale Reported · Chickaloon, AKSale reportedBuilt 1962 · S/N 2021N7898GMccutcheon Frank Jr · Scottsboro, ALBuilt 1970 · S/N 17259598N7898HOdean Steve6663 · Palmer, AKS/N 12-802
Back to AD 81-18-04 R2