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.

N57458Flytrek3 LLC · Palmer, AKBuilt 1973 · S/N 509-73N5745HManos Theodore W II · Omaha, NEBuilt 1949 · S/N 16-358N5745PMiller Aaron T · New Braunfels, TXS/N 24-819N5745QHuseman Joseph F · De Witt, IABuilt 1965 · S/N 3159N5745UMccormick Todd L · Ankeny, IAS/N 28-26565N57461Hall Willard · Beaumont, TXBuilt 1973 · S/N 949-73N57468Lease Gregory C · Grand Rapids, MNBuilt 1973 · S/N 514-73N57469Miller Christopher A · Chico, CABuilt 1973 · S/N 951-73N5746PYinyan Tech US Inc · Brea, CANon-citizen corporation, flight hours not reportedBuilt 1959 · S/N 24-820N5746QKing Jeremy · Sandy Springs, GAS/N 3075N5746USale Reported · Crystal, MNSale reportedBuilt 1969 · S/N 28-26567N57472Kutztown Aviation Service Inc · Germansville, PABuilt 1973 · S/N 512-73N57473Duncan Michael E · Auburn, CABuilt 1973 · S/N 378-73N57474Harding William R Jr · Quinlan, TXBuilt 1973 · S/N 950-73N57476Boucher Gregg D · Hinsdale, MTBuilt 1973 · S/N 516-73N5747DMcmillian Roger L · Camdenton, MOBuilt 1956 · S/N 22-4447N5747FMsol Air LLC · Lakeland, FLBuilt 1968 · S/N 28-25048N57481Bartels Pamela K · Marion, NCBuilt 1973 · S/N 952-73N57488Rocky 80 Inc · Ethridge, MTBuilt 1973 · S/N 521-73N5748PBaxter Randall T · Maple, NCBuilt 1959 · S/N 24-823N57492Trimble Tanner J · Blue Rapids, KSBuilt 1984 · S/N 24-1455N5749NPickerell Brian E · Longmont, COBuilt 1955 · S/N 0003N5749WDch Aviation LLC · Owasso, OKBuilt 1963 · S/N 28-1467N5749XFlash Aviation LLC · Elkton, MDBuilt 1984 · S/N 24-1454N5749ZTroy Michael J · Albion, NYBuilt 1963 · S/N 22-9588N574AKFirey Charles R · Anchorage, AKBuilt 2015 · S/N 001N574ATAtp Aircraft 3 LLC · Wilmington, DEBuilt 2005 · S/N 4496199N574BFKrusemark Emma A · Pender, NES/N 28-25047N574CACivil Air Patrol · Maxwell Afb, ALBuilt 2008 · S/N 18282121N574CLMaier Ludwig Peter · Port Orange, FLS/N 574N574CMMarshall Aviation Services Inc · Elkhart, INBuilt 2008 · S/N 99N574CZSiu Bernard K · Diamond Bar, CABuilt 2016 · S/N 1N574DEMuggsys Aviation Services LLC · Crittenden, KYBuilt 1974 · S/N 172-62959N574DGSmith Bruce Martin Trustee · Spirit Lake, IDBuilt 2003 · S/N 777N574FLDynamic Aviators LLC · San Angelo, TXS/N 28-7125421N574HBIngram Grant Leigh · Hurricane, UTBuilt 2021 · S/N 4134CN574KBBrooks Flyers LLC · Willow, AKBuilt 2021 · S/N 22046CN574KRPhoenix Rising Aviation Inc · Bartlesville, OKS/N 22-5273N574LBThoft Matthew M · Wasilla, AKBuilt 1977 · S/N 18-7709109N574LCGehrer Aviation LLC · Wichita, KSBuilt 2021 · S/N 3364N574MMMyers Benny R · Wasilla, AKBuilt 2023 · S/N 100N574NDSunrise Aviation Inc · Ormond Beach, FLBuilt 2009 · S/N 172S10943N574PRSoto Angel L · Las Piedras, PRBuilt 1965 · S/N 32-241N574RJJets To Helis LLC DBA · Chandler, AZBuilt 2023 · S/N 4888N574XAsher Curtis K · Wasilla, AKS/N 18-1030N57503Martin William A · Nashville, TNBuilt 1973 · S/N 95-73N57505Archipelago Group Llcc · Alexandria, VAS/N 267-73N5750MStites Holdings LLC · Seattle, WAS/N 24-1457N5750PRoberts Donald W · Flower Mound, TXBuilt 1959 · S/N 24-825N5750QMelnyk Richard V · Uniontown, PABuilt 1965 · S/N 3077
Back to AD 81-18-04 R2