OpenAirDocs.org
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.

N4974LPotratz Douglas R · Oshkosh, WIBuilt 1967 · S/N 28-4348N4975FFg Aviation LLC · La Jolla, CABuilt 1979 · S/N 17273112N4975GBermuda Dunes Flight Training LLC · Palm Desert, CABuilt 1979 · S/N 17273522N4975JP&N Corp · Marion, IABuilt 1968 · S/N 28R-30727N4975LMcnabb Brandy T · Milton, FLS/N 28-4349N4975VMiller David M · Fort Worth, TXBuilt 1980 · S/N 172RG0440N49769Granzow Jared D Trustee · Powell, OHBuilt 1979 · S/N 15283508N4976FLytle John A · Anaheim, CABuilt 1980 · S/N 172-73113N4976GOklahoma Airmen Flying Club Inc · Jenks, OKS/N 17273523N4976LLawrence Kenneth White · Chuckey, TNBuilt 1967 · S/N 28-4350N4976PBecher Dustin Michael · Fort Wayne, INS/N 15284868N4976SLogsdon David · Carmel, INBuilt 1970 · S/N 28R-35692N4976VPlane Fun Inc Tr Trustee · Snellville, GABuilt 1980 · S/N 172RG0441N4977JJad Corp · Saint Cloud, MNBuilt 1968 · S/N 28R-30730N4977LApple Tree Aviation LLC · Gibsonia, PABuilt 1967 · S/N 28-4352N4977SMatheaus Michael · Sequin, TXBuilt 1970 · S/N 28R-35696N4977YQuality Aviation Inc · Marana, AZBuilt 1968 · S/N 25-4748N4977ZMcdorman Joshua · Collinsville, OKS/N 22-8583N49780Farrell David R · Marysville, WABuilt 1978 · S/N 15281314N49785Wings Over Texas Holdings LLC · Denton, TXBuilt 1979 · S/N 15283514N4978BSpring City Aviation East LLC · Oconomowoc, WIFirst renewal noticeBuilt 1979 · S/N 15283736N4978GJin Jin Aviation LLC · Anchorage, AKBuilt 1979 · S/N 17273525N4978LBarr Stephen L · Spicewood, TXBuilt 1980 · S/N 15284247N4978TRoth Robert A · Pacific Palisades, CABuilt 1981 · S/N R18201811N4978VGeorgeson Troy D · Sheyenne, NDBuilt 1980 · S/N 172RG0442N49792Sierra Lima Aviation LLC · Riverton, UTS/N 15283517N4979ESmith Corey C · Campton, NHBuilt 1984 · S/N 782N4979SDunn James J · San Ramon, CABuilt 1970 · S/N 28R-35698N4979VRobertson Roy E · Marion, IABuilt 1980 · S/N 172RG0443N497BWSwartz Taylor A · Fayetteville, NCBuilt 2014 · S/N 90762N497DSDelaware State University · Dover, DEBuilt 1978 · S/N 28-7816567N497ERPlane Three Ltd · Wilmington, DEBuilt 1998 · S/N 17280673N497FLRiggin Flight Service Inc · Madison, SDBuilt 1971 · S/N 28-7125314N497LAPiper 3 LLC · Chestnut Ridge, NYBuilt 2022 · S/N 28020075N497LTRonneberg Dave H · Santa Monica, CABuilt 2010 · S/N L-002N497SJFxe Flightcenter Corp · Fort Lauderdale, FLBuilt 2000 · S/N 172S8497N497TCPinnacle Aviation Services Inc · Encinitas, CABuilt 2005 · S/N 172S9870N49808Holloway James H · Merritt Island, FLBuilt 1979 · S/N 15283519N49809Anderson Erik G · Deerfield Beach, FLBuilt 1976 · S/N 14055N4980PLewis Clinton A · Antlers, OKBuilt 1963 · S/N 27-584N4980SGrenie Arles A · Richland Center, WIBuilt 1970 · S/N 28R-35699N4980TAdams Aviation Services Inc Trustee · Wilmington, DEBuilt 1981 · S/N R18201813N4980UUniveristy Of Oklahoma · Norman, OKBuilt 2005 · S/N 2842229N4980ZElliott Charles · Rock Spring, GABuilt 1961 · S/N 22-8588N49818Wings 'N' Rotors LLC · Boise, IDBuilt 1978 · S/N 15281338N4981GGillespie John · Austin, TXBuilt 1979 · S/N 17273528N4981LBasinger Robert C · Freedom, PABuilt 1967 · S/N 28-4356N4981PTri State Aero Inc · Martinsburg, WVBuilt 1963 · S/N 27-585N4981SLacallle Darren M · Dover, TNBuilt 1970 · S/N 28R-35701N4981VWasatch Industries LLC · Ogden, UTS/N 172RG0444
Back to AD 81-18-04 R2