OpenAirDocs.org
AD 81-18-04 R2

Registered aircraft · 81,720

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.

N180VASmith Trevor A · Justin, TXBuilt 2002 · S/N 897N180VBPersons Richard A · Arroyo Grande, CABuilt 2003 · S/N 5307N180VMMarshall Glen E · Capitola, CABuilt 2007 · S/N 47014TN180WPPietsch Warren A · Minot, NDBuilt 1980 · S/N XT-1N180XCGilbert James C Trustee · North Plains, ORBuilt 2016 · S/N CC19-0013N180XXDana Glen A · Kewanee, ILBuilt 1996 · S/N 0072N1810PTurner Christian Millard · Eastsound, WABuilt 1955 · S/N 22-2589N1811GYelle Flyers LLC · Cashion, OKBuilt 1968 · S/N 584N1811JJonas Christian R · Corpus Christi, TXBuilt 1968 · S/N 28-24239N1811KGage Lewis Trustee · Reno, NVBuilt 1946 · S/N 4538N1812Marsh John E · Washington, DCS/N RG-1N18129Loftics LLC · Kennewick, WABuilt 1976 · S/N 17702530N1812EAtp Aircraft 6 LLC · Wilmington, DEBuilt 2018 · S/N 172S12168N1812FLynch Mark R · Forest Lake, MNBuilt 1981 · S/N WA-279N1812JEcho Aviation II LLC · Akron, OHBuilt 1968 · S/N 28-24240N1812PCarothers Edward L · Jersey Shore, PABuilt 1955 · S/N 22-2591N1812ZHendrickson Todd R · Woodstock, ILBuilt 1981 · S/N WA-280N1813ALawrence Mark J · Rouses Point, NYS/N 22-516N1813GSenior Flyers LLC · Kalamazoo, MIBuilt 1968 · S/N 596N1813JSale Reported · Princeton, MNSale reportedBuilt 1968 · S/N 28-24242N18141Schulte James P · Hurst, TXBuilt 1951 · S/N 181332N1814DAndover Flight School Inc · Andover, NJBuilt 1958 · S/N 18-6406N1814JGunn John R · Eloy, AZBuilt 1968 · S/N 28-24243N1814NHenry Mark A · Dickinson, TXBuilt 1981 · S/N WA-282N1814QWalsh Michael J · Clemmons, NCS/N WA-283N1814VBeyer Leasing Co · Paw Paw, MIS/N 17263759N18151Briggs James E · Nashua, NHBuilt 1981 · S/N WA-285N18159Beck Thomas G · Walled Lake, MIBuilt 1976 · S/N 17702534N1815ALa Viano Kenneth J · Westwood, NJBuilt 1952 · S/N 22-521N1815JDodson International Parts Inc · Rantoul, KSBuilt 1968 · S/N 28-24244N1816Hannesh LLC · Missoula, MTBuilt 2018 · S/N 3316N1816QS And E Airplane Company · Puyallup, WABuilt 1971 · S/N 177RG0216N1816TGq Aviation LLC · Cherry Hill, NJBuilt 1971 · S/N 28-7125173N1816ZWestern Anesthesia Assn · Richland, WABuilt 1981 · S/N M-232N18174Connell William J · Woodinville, WABuilt 1976 · S/N 17702535N18176Reese Flying Service Inc · Muncie, INBuilt 1941 · S/N A-802N1817EAtp Aircraft 6 LLC · Wilmington, DEBuilt 2018 · S/N 172S12169N1817GJacelon Charles E · Little River, SCBuilt 1968 · S/N 409N1817JCarey Thomas W Jr · Springfield, ILBuilt 1968 · S/N 28-24247N1817QJohnston Bernard D · Puyallup, WAFirst renewal noticeBuilt 1971 · S/N 177RG0217N1817TR J Services LLC · Centerton, ARBuilt 1971 · S/N 28-7105142N18184Lerille Red · Lafayette, LABuilt 1941 · S/N A-810N18186Davies Samuel R · Port Angeles, WAS/N A-812N1818GPine Wind Aviation LLC · San Francisco, CABuilt 1968 · S/N 561N1818JDavey Aaron A · Topeka, KSBuilt 1968 · S/N 28-24248N1818RSideline Services LLC · Pearland, TXBuilt 1978 · S/N R18200572N1818TCopp Gary P · Carson City, MIBuilt 1971 · S/N 28-7105143N1819Peters Sean T · Oak Harbor, OHBuilt 1959 · S/N 22-6705N1819BDudinsky Todd M · Eagle River, AKS/N 20008CN1819DSpeedcraft Industries LLC · Port Jefferson, NYBuilt 2020 · S/N 1188-2020
Back to AD 81-18-04 R2