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.

N98923Costa Flying Service Inc · Painted Post, NYBuilt 1985 · S/N 17276381N98927Deleon Joseph M · Saint Petersburg, FLFirst renewal noticeBuilt 1946 · S/N 12-279N9892GFritz John P · Belvidere, NJBuilt 1971 · S/N 17259792N9892PArizona Soaring Inc · Maricopa, AZBuilt 1975 · S/N 25-7556215N9892QLytle Jack J · Omaha, NEBuilt 1975 · S/N 17265836N9892YWraith Daniel T · Wasilla, AKBuilt 1961 · S/N 7GCB-77N98932Podeweltz Wayne Leo · Merrill, WIBuilt 1946 · S/N 12-285N98935Meketa George C · La Vernia, TXS/N 12-290N9893LStansfield Tod A · Elm Grove, WIBuilt 1974 · S/N AA1B-0493N9893QDougherty Casey · Rock Island, WABuilt 1975 · S/N 17265837N9893WSky High Aviation LLC · Streamwood, ILBuilt 1967 · S/N 28-23413N98941Flaglor Thomas R · Mosheim, TNS/N 12-296N98944Phelps Douglas E · Salem, ORBuilt 1946 · S/N 12-299N9894G1s6 Flying Club Inc · Sandpoint, IDS/N 17259794N9894LHilton Allen J A Jr · Justin, TXBuilt 1974 · S/N AA1B-0494N9894QKarpov Konstantin A Trustee · Fort Bragg, CABuilt 1975 · S/N 17265838N98954Emerson Solutions LLC · Bellingham, WABuilt 1985 · S/N 17276384N98959Delaware Corp · Topping, VABuilt 1946 · S/N 12-313N9895FRetro Modern Aviation LLC · Manitou Springs, COBuilt 1997 · S/N 17280179N9895GKellerman Roger B · Rockford, ILBuilt 1971 · S/N 17259795N9895QCk Leasing Services LLC · Wilmington, DEBuilt 1975 · S/N 17265839N9895VTogo Aviation Services LLC · Palmer, AKBuilt 1974 · S/N 17264550N98960Buiqui Aerospace Corp · Kissimmee, FLBuilt 1985 · S/N 17276387N98961Knox Norman B · Billings, MTBuilt 1946 · S/N 12-315N98962Woodward Lowell L · Alpine, TXBuilt 1946 · S/N 12-316N98965Cook Steven A · Vineland, NJBuilt 1946 · S/N 12-320N9896PLees Aerial Spraying Inc · Aberdeen, IDBuilt 1975 · S/N 25-7556219N9896UAmaya Ricardo · Shelby, NCBuilt 1977 · S/N AA5A0296N9896WKnapp Joseph E Jr · Clermont, FLBuilt 1967 · S/N 28-23416N9896YFrisby James A · Palmer, AKS/N 7GCB-95N98971Whitaker Eric Lee · Detroit, TXBuilt 1946 · S/N 12-327N98978Harmon Jon E · Turner, MTBuilt 1946 · S/N 12-335N98979Mc Bride Robert W Jr · Cedar Park, TXBuilt 1946 · S/N 12-336N9897DRobinson Scot K · Powderville, MTBuilt 1959 · S/N 18-6923N9897PMississippi State University Soaring Club Inc · Mississippi State, MSBuilt 1975 · S/N 25-7556220N9897QAbove All Aviation Inc · Santa Barbara, CABuilt 1975 · S/N 17265841N9897YCline Braxton L · Wasilla, AKBuilt 1962 · S/N 7GCB-117N98981Airplane And Drone Flight Instruction LLC · Orlando, FLBuilt 1985 · S/N 17276390N98985Sanker Frank Trustee · Keller, TXBuilt 1946 · S/N 12-342N9898DBailey Ronald C · Anchorage, AKBuilt 2009 · S/N 001N9898QSecond Wind Aviation Corp · Friday Harbor, WABuilt 1975 · S/N 17265842N9898UOlenick Christopher M · New Richmond, OHBuilt 1977 · S/N AA5A0298N98992Mike Pikovsky Aviation LLC · Plymouth, MNBuilt 1946 · S/N 12-350N98994Lindeen Michael L · Anchorage, AKBuilt 1946 · S/N 12-352N98999Rodenhouse Robert H · Port Orange, FLBuilt 1946 · S/N 12-360N9899GWings Over Texas LLC · Denton, TXBuilt 1971 · S/N 17259799N9899QBrown Richard K · East Falmouth, MABuilt 1975 · S/N 17265843N9899UStott Rick T · Bynum, MTBuilt 1977 · S/N AA5A0299N989AMcghan Corey A · Big Lake, AKS/N 12-2590N989CDDoyle Charles P · Webster, MNBuilt 2008 · S/N 1075-2008
Back to AD 81-18-04 R2