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.

N7833PPeters Jakob G · Tempe, AZS/N 24-3053N7833WLukehart Steve D · Lincoln, NEBuilt 1964 · S/N 28-1850N78341Davis Glenn A · Fair Oaks, CABuilt 1968 · S/N 17257575N78345Peter Claire Ltd · George TownBuilt 1962 · S/N 500B-1237-107N78349Raker Theodore B · Hahira, GABuilt 1968 · S/N 17257578N7834GSmith Perry L · Brook Park, MNS/N 17259534N7834HWilde Air Service-Huron LLC · Volga, SDBuilt 1946 · S/N 12-734N7834NVector Aviation LLC · Mentor, OHBuilt 1969 · S/N 28-5288N7834PRegistered aircraftBuilt 1962 · S/N 24-3054N7834VMorris Tommy R · Houston, TXBuilt 1964 · S/N 2870N7834WCleek Norris E · Orland, CABuilt 1964 · S/N 28-1851N7834YBall Half Out LLC · Mesa, AZBuilt 1965 · S/N 30-911N78351Caron John · Ellsworth, MIBuilt 1968 · S/N 17257579N78354Tonar Richard J Jr · Omaha, NES/N 17257581N78355Fleming Gary R · Wickliffe, KYBuilt 1968 · S/N 17257582N78358All American Aviation LLC · Fort Worth, TXS/N 17257585N78359Burns Stanley R · Flagler, COBuilt 1968 · S/N 17257586N7835NOrrill Bill · Godfrey, ILBuilt 1969 · S/N 28-5289N7835YRegistration Pending · Lewes, DERegistration pendingBuilt 1965 · S/N 30-912N78367Dardis Barry J · Great Falls, MTBuilt 1968 · S/N 17257587N7836NMelancon Scottie J · Baton Rouge, LABuilt 1969 · S/N 28-5291N7836PKearney Kory · Papillion, NEBuilt 1962 · S/N 24-3056N78371Lillace Kevan · Shelby, MTBuilt 1968 · S/N 17257590N78375Bozeman Leasing Inc · Bozeman, MTS/N 17257593N7837GGlass Jay Thomas · El Dorado, ARBuilt 1970 · S/N 17259537N7837HCounsell Michael J · Moses Lake, WABuilt 1946 · S/N 12-737N7837MDiamond B Farm Inc · Gamaliel, KYBuilt 1962 · S/N 2373N7837PMobbd LLC · Vero Beach, FLS/N 24-3057N7837WHock Matthew G · Culbertson, NEBuilt 1964 · S/N 28-1854N78385Amf Aviation LLC · Dallas, GABuilt 1968 · S/N 17257595N78388Fortner Weston · Fort Payne, ALBuilt 1968 · S/N 17257596N7838NWright David P Jr · Chandler, AZBuilt 1969 · S/N 28-5293N78395Fgds LLC · Louisville, KYBuilt 1968 · S/N 17257599N7839DMartin David · Jackson, GABuilt 1957 · S/N 22-5489N7839GGerty Air LLC · Sidney, MEBuilt 1970 · S/N 17259539N7839NHaddle Eddie J · Lindon, UTBuilt 1969 · S/N 28-5295N7839VHafter Mark S · Cincinnati, OHBuilt 1965 · S/N 461N783AJApple Ronald L · Fort Myers, FLBuilt 1979 · S/N AA5B1093N783BWestside Air Inc Renton · Renton, WABuilt 1958 · S/N TD-55N783CPCivil Air Patrol · Maxwell Afb, ALBuilt 2006 · S/N 18281783N783DGJeffery & Weiss Holdings LLC · Long Beach, CABuilt 1980 · S/N 17274063N783EAElevation Air Capital LLC · Janesville, WIBuilt 2020 · S/N 172S12555N783EPEpic Aviation Inc · New Smyrna Beach, FLBuilt 2022 · S/N 172S12913N783EREmbry-Riddle Aeronautical University Inc · Prescott, AZBuilt 2026 · S/N 172S13575N783FMFmfa Inc · Wilmington, DEBuilt 1980 · S/N 17274259N783GSSchulenberg Gilbert H · Buffalo, NYBuilt 2008 · S/N 70931N783LAN783la LLC · Philadelphia, PABuilt 2025 · S/N 28020215N783LKPullis Troy K · Hutchinson, MNBuilt 1959 · S/N 22-6900N783LULiberty University School Of Aeronautics · Lynchburg, VABuilt 2015 · S/N 4496381N783MSKornacki Daniel · Fayetteville, GABuilt 2000 · S/N 80783
Back to AD 81-18-04 R2