OpenAirDocs.org
AD 81-04-05 R1

Registered aircraft · 1,079

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-04-05-R1')
    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-04-05-R1')
  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.

N54195Decruz Peter John · Hattiesburg, MSBuilt 1974 · S/N 27-7405472N54198Valiair Lc Trustee · Casper, WYS/N 27-7405474N54221Emission-Air Inc · Lexington, NCBuilt 1974 · S/N 27-7554014N54224Coosa Air LLC · Rome, GABuilt 1974 · S/N 27-7554017N54225Jpr Capital LLC · San Juan, PRBuilt 1974 · S/N 27-7554018N54236B & R Aircraft LLC · Wadsworth, OHBuilt 1974 · S/N 27-7554030N54238Backcreek Farms Inc · Rougemont, NCBuilt 1974 · S/N 27-7554032N54240Pacific Fleet Aviation LLC · Rochester, NYBuilt 1974 · S/N 27-7554034N54245Pacific Fleet Aviation LLC · Rochester, NYBuilt 1974 · S/N 27-7554039N54258Nesbeda Peter J · Marlborough, NHBuilt 1974 · S/N 27-7554046N5431YThompson Sherrel L · Pembroke Pines, FLBuilt 1964 · S/N 27-2508N5437YHayman Russell P · Ocean City, MDS/N 27-2514N5447YAnderson Michael W · Wayzata, MNBuilt 1964 · S/N 27-2528N54504Castor Care LLC · Mount Pleasant, SCS/N 27-3369N5454YMatthews Grover · Fairborn, OHBuilt 1964 · S/N 27-2539N54621Atlantic Resources Of Miami Inc · Deland, FLS/N 27-7554036N5470YWeber Mark J · Dalton, MABuilt 1964 · S/N 27-2560N54757Pacific Fleet Aviation LLC · Rochester, NYBuilt 1975 · S/N 27-7554068N54772Watts John J · Murchison, TXBuilt 1975 · S/N 27-7554080N54775Hankins Shannon G · Tulsa, OKBuilt 1975 · S/N 27-7554082N54796Pacific Fleet Aviation LLC · Rochester, NYBuilt 1975 · S/N 27-7554097N54808Wsk Inc · Wolfeboro, NHBuilt 1975 · S/N 277554106N54809Mgc LLC · Brandon, FLBuilt 1975 · S/N 27-7554108N54810Pacific Fleet Aviation LLC · Rochester, NYBuilt 1975 · S/N 27-7554109N54811Simms Linda Ann Murray Trustee · Westminster, MDBuilt 1975 · S/N 27-7554110N54854Registration Pending · Saint Augustine, FLRegistration pendingBuilt 1975 · S/N 27-7554154N54857Mach Tuck LLC · Daytona Beach, FLBuilt 1975 · S/N 27-7554157N54858Advanced Aviation Group LLC · Frederick, MDBuilt 1975 · S/N 27-7554158N54861Fly Car Aviation LLC · North Fort Myers, FLBuilt 1975 · S/N 27-7554159N54862J&P Master Flooring Corp · Lauderdale Lakes, FLBuilt 1975 · S/N 27-7554161N54870Senter Carl V · Coeymans, NYBuilt 1975 · S/N 27-7554165N5494YSchildberg Gregory M · Casey, IABuilt 1964 · S/N 27-2587N5495YBerman Samuel I · Minneapolis, MNBuilt 1964 · S/N 27-2588N54AWWilson Cecil P · Lithonia, GABuilt 1974 · S/N 27-7405392N54MVNeil Anthony Foster Holdings LLC · Santa Rosa, CABuilt 1976 · S/N 27-7654043N54STMac Air Aviation LLC · Xenia, OHBuilt 1974 · S/N 27-7405358N5502YCreative Strategies Inc · Grayson, KYBuilt 1964 · S/N 27-2596N5533YAce Tomato Co LLC · Daytona Beach, FLBuilt 1964 · S/N 27-2631N5545YKolarek Frank · West Nyack, NYFirst renewal noticeBuilt 1964 · S/N 27-2644N555PRHarlan Thomas D · Fresno, CABuilt 1969 · S/N 27-4248N5579YHepner Glenn L · New Port Richey, FLBuilt 1964 · S/N 27-2684N5588YBrennan Thomas F · Titusville, PAS/N 27-2695N559JTOrian Dillon R · Malibu, CABuilt 1960 · S/N 27-286N55JELakes Area Aviation LLC · Little Falls, MNS/N 23-772N55MTKramp William J · Post Falls, IDBuilt 1966 · S/N 27-3575N55PBHorizon Dreams LLC · Homer, GABuilt 1962 · S/N 27-2184N560DBAnderson Aerial Spraying Svc Inc · Canby, MNBuilt 1964 · S/N 27-2722N5622YStephan Jesse A · Richmond, TXBuilt 1964 · S/N 27-2732N5629YTart John W · Fayetteville, NCBuilt 1964 · S/N 27-2741N5644YGantt William M · Port Orange, FLBuilt 1965 · S/N 27-2758
Back to AD 81-04-05 R1