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.

N55044Yale Aviation Inc · New Haven, CTBuilt 1973 · S/N 28-7305299N55049Spanier Sherri Kay · Belleview, FLBuilt 1973 · S/N 28-7310111N5504FWieselquist Kermit L · Westford, MABuilt 1968 · S/N 28-24843N5504KWhite Traci Michelle · Manasquan, NJBuilt 1978 · S/N 1047-78N5504NWighs Terry L · Fairbanks, AKBuilt 1978 · S/N 1264-78N5504PLanghorst Richard C · Waltham, MEBuilt 1958 · S/N 24-567N5504QDoll Electric Co Inc · Murphys, CABuilt 1965 · S/N 605N5504SBoomer Aviation Inc · Fort Walton Beach, FLBuilt 1978 · S/N 277-78N5504WTaylor Deric C · Seguin, TXBuilt 1962 · S/N 28-591N5504YTarkington John W · Almyra, ARBuilt 1978 · S/N 423-78N55051Wings Over Texas Holdings LLC · Denton, TXBuilt 1973 · S/N 34-7350166N55055Martan LLC · Kansas City, MOBuilt 1973 · S/N 28-7305301N55057Smooth Air LLC · Churubusco, INBuilt 1973 · S/N 28-7305302N55058Eggensberger Edmund G · Simpsonville, SCS/N 28R-7335174N5505FSerafinowicz Ronald P · Gilbert, AZBuilt 1968 · S/N 28-24844N5505HKupferschmidt W Alan Trustee · Lake Elmo, MNBuilt 1978 · S/N 1038-78N5505LRegistration Pending · Saint Johns, FLRegistration pendingBuilt 1974 · S/N AA5-0505N5505MCapozzi Eugene L · Kalispell, MTBuilt 1978 · S/N 424-78N5505NMargolies Lars · Goldens Bridge, NYBuilt 1978 · S/N 1266-78N5505PLandmann Ryan J · Fort Walton Beach, FLS/N 24-568N5505QReynolds C J · Cornelius, NCBuilt 1965 · S/N 2941N5505UPaper Plane Aviation LLC · Avon Park, FLBuilt 1969 · S/N 28-26215N5505WPerez Daniel E · Parsons, KSBuilt 1962 · S/N 28-592N55064Western Skyways Inc · Montrose, COBuilt 1973 · S/N 28-7325317N55065Lynch Timothy B · Aguadilla, PRBuilt 1978 · S/N 427-78N55066Premier Capital Enterprises LLC · Hurricane, UTS/N 28-7305303N55067Hinsch Delano G · Larchwood, IABuilt 1978 · S/N 428-78N55069Tre Aviation Corp · Wilmington, DEBuilt 1973 · S/N 28R-7335177N5506CBattle Creek Powersports LLC · Jasper, TNBuilt 1978 · S/N 1267-78N5506HWoods George M · Anchorage, AKS/N 1240-78N5506JSoaring For Christ LLC · Big Lake, AKBuilt 1968 · S/N 32-1051N5506LKoster Michael Richard · Plano, TXS/N AA5-0506N5506MCloud Kicker Aviation LLC · Kalamazoo, MIBuilt 1978 · S/N 1040-78N5506UHumberto Moreno · Mulberry, FLBuilt 1969 · S/N 28-26214N5506WMchatton Dret A · Redding, CABuilt 1962 · S/N 28-593N5506ZOakcrest Management Inc · Brownsville, TXBuilt 1978 · S/N 364-78N55072Lorenzo John V · Tulare, CABuilt 1978 · S/N 1269-78N55075Paris Air Inc · Vero Beach, FLS/N 34-7350170N55078Tiritilli Robert · Mission Viejo, CABuilt 1973 · S/N 28-7325320N5507HAdair Caden S · Anchorage, AKBuilt 1978 · S/N 1273-78N5507LFletcher Alex J · Weston, WIBuilt 1974 · S/N AA5-0627N5507PMccleskey Nicholas J · Mcminnville, ORBuilt 1978 · S/N 1043-78N5507WBurnett Fred · Greenbrier, ARBuilt 1978 · S/N 365-78N55080Keath Brian S · Kansas City, MOBuilt 1973 · S/N 28-7305305N55087Fosso Christopher M · Glendale, AZBuilt 1973 · S/N 28-7305308N5508JPaetzold Larry E · Brownwood, TXBuilt 1978 · S/N 1048-78N5508LDe Lint Marcus W · Cove, ORBuilt 1978 · S/N 1049-78N5508MLindvig Thomas H · Williston, NDBuilt 1978 · S/N 1272-78N5508QSchmidt James A · Richmond, VABuilt 1965 · S/N 707N5508WEkkel Bob J · Newaygo, MIBuilt 1962 · S/N 28-596
Back to AD 81-18-04 R2