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.

N600HHFleming Mike R · Troy, MOBuilt 1974 · S/N 600N600HJRavotti Air LLC · Leechburg, PABuilt 1978 · S/N 28-7990004N600HYMotonaga Gregg K · Soldotna, AKBuilt 2006 · S/N 2366N600JLMinisterio Internacional Gracia Y Poder Inc · Houston, TXBuilt 1973 · S/N 32-7400010N600KKFeielin Kenneth M · Paris, OHBuilt 2007 · S/N 25488N600PCRudd Wayne · Basalt, COBuilt 1993 · S/N 714-93N600PFEastern Aviation Corp · Whitestone, NYBuilt 1977 · S/N 28-7816109N600PKGetzel Air LLC · Conover, WIBuilt 2008 · S/N 18282082N600RBGates Steven · Midlothian, TXBuilt 1974 · S/N 247N600SEMcgavock Randall J · Camp Verde, AZBuilt 1984 · S/N 1279N600SHReynolds Phillip Micah · Jefferson City, TNBuilt 1994 · S/N H002N600SRCsd Enterprises Inc · Wilmington, DEBuilt 2000 · S/N 0751N600TLLbaviation LLC · Wheatland, WYS/N 1148N600VFBravo Gulf LLC · Cleveland, OHBuilt 1980 · S/N 6007578061229N600VVMindy Limited LLC · Muscatine, IABuilt 1975 · S/N 17264773N600WPort Of Tillamook Bay · Tillamook, ORS/N 1N600WTBaldauf Mark H · Nova, OHBuilt 1986 · S/N 1480N60104Theo-N60104 LLC · Wilmington, DEBuilt 1978 · S/N M-2093N60106Lutzko Timothy R · Ocean View, DEBuilt 1978 · S/N M-2094N6010CBig Bend Community College · Moses Lake, WABuilt 1978 · S/N MB-905N6010DTrenkamp John F · Oskaloosa, IAS/N 22-4662N6010LBergstrom Robert L · Amelia, VABuilt 1972 · S/N AA5-0110N6010PSniffen Kirby K · Sycamore, OHBuilt 1959 · S/N 24-1104N6010YSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1993 · S/N 14589N6011FAmeriflyers Of Texas Inc · Addison, TXBuilt 2022 · S/N 28020090N6011JSymond Clarence B · Eastover, NCBuilt 1978 · S/N MC-625N6011LBiondich Amy Sue · Rubicon, WIBuilt 1972 · S/N AA5-0111N6011QHikari Aviation Ltd · Torrance, CABuilt 1978 · S/N ME-100N6011UJin Jin Aviation LLC · Anchorage, AKBuilt 1978 · S/N ME-101N6012FSanders Flight Training Center · Jasper, ALBuilt 1965 · S/N TD-616N6012LCloudkicker Lc · Sioux Falls, SDBuilt 1972 · S/N AA5-0112N6012QClassic Aircraft LLC · West Point, NEBuilt 1965 · S/N 864N6012U6012u LLC · Union Gap, WABuilt 2006 · S/N 172S10168N6012YBieszczad Wally · Bloomingdale, ILBuilt 1979 · S/N M-2106N6012ZChristiansen Aviation LLC · Wilmington, DEBuilt 2006 · S/N 172S10150N60135Charles Ray Aviation LLC · Fleming Island, FLBuilt 1979 · S/N M-2105N6013DBennett Garrett Douglas · Bonners Ferry, IDBuilt 1956 · S/N 22-4665N6013JAerodrome LLC · Louisville, KYBuilt 2006 · S/N 172S10153N6013KLdm LLC · Cuba, MOBuilt 2006 · S/N 18281795N6013LCraven Jeremy A · Winter Garden, FLBuilt 1972 · S/N AA5-0113N6013SStomio LLC · Covina, CABuilt 2006 · S/N 18281797N6013VFlynn James H Jr · Saratoga Springs, NYBuilt 2006 · S/N 18281798N6013ZVandelay Aviation LLC · San Diego, CABuilt 1978 · S/N ME-112N60143H2 Link Company · Lewes, DEBuilt 2008 · S/N 172S10142N6014CHangar 14 LLC · Spokane, WABuilt 1978 · S/N R18200352N6014PTwo Men And A Plane Inc · Dearborn, MIBuilt 1959 · S/N 24-1109N6014WLeaders Bob O · Clear Lake, MNBuilt 1964 · S/N 28-20014N6014YBackscheider Eric D · La Follette, TNBuilt 1997 · S/N 24367N6014ZSimpson Alena A · Blue Eye, MOBuilt 1979 · S/N M-2141N60155Jls Aviation LLC · Sarasota, FLBuilt 2006 · S/N 172S10167
Back to AD 81-18-04 R2