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.

N5554ZWeddle Curtis E · Iowa Park, TXBuilt 1962 · S/N 22-9347N55551Mahmud Fawzi S · Enid, OKBuilt 1973 · S/N 28-7325328N55558Wagner Mark · Medina, WABuilt 1973 · S/N 28-7325368N55559Mcconnachie Craig · Bullhead City, AZBuilt 1973 · S/N 28-7305392N5555AGellner Sy D · Billings, MTS/N 28-860N5555DReed Tony S · Mullica Hill, NJBuilt 1999 · S/N 18280459N5555JSawyer James K · Odessa, FLBuilt 1968 · S/N 32-1019N5555VJensen Jeffrey S · Alliance, NEBuilt 1971 · S/N 1N5555WLemieux Patrick · San Luis Obispo, CABuilt 1962 · S/N 28-647N5555ZKramer Brian J · Seattle, WABuilt 1962 · S/N 22-9348N55563Sanchez Alejandro Arturo · El Paso, TXBuilt 1973 · S/N 28-7325433N55564Moore Ryan J · Corvallis, ORBuilt 1973 · S/N 28-7305414N55565Brickweg Kurt J · Cincinnati, OHBuilt 1973 · S/N 28-7305415N55566Speck G Dan · Roaring Spring, PABuilt 1973 · S/N 28R-7335252N5556PEasley Gary M · Comanche, TXBuilt 1958 · S/N 24-620N5556SSmith Steven D · Sanger, TXBuilt 2023 · S/N 24078N5556UCynthiana Flying Group Corp · Cynthiana, KYBuilt 1969 · S/N 28-26282N55578Gardiner Merrill L · Traverse City, MIBuilt 1973 · S/N 28-7325435N5557JSmtm Holdings Inc · Wilmington, DEBuilt 1991 · S/N 1326N5557PN5557p Delta Charlie Aviation Inc · Rockwall, TXBuilt 1958 · S/N 24-621N55585Kankakee Area Flying Group LLC · Gilman, ILBuilt 1973 · S/N 28-7305418N5558FConner Brad S · Waynesville, OHBuilt 1968 · S/N 28-24898N5558WPatterson Troy V · Arlington, TXS/N 28-650N55593Flying Life LLC · Fuquay Varina, NCBuilt 1973 · S/N 28-7305400N55596Outdoor Products Of Louisiana LLC · Heflin, LAS/N 28-7325439N55597Arndt Douglas E · Marion, WIBuilt 1973 · S/N 28-7305421N55598Smith Gregory E · Manila, ARS/N 28-7305422N55599Manning Holdings LLC · Portland, ORBuilt 1973 · S/N 28R-7335256N5559FEsteban Granwel · Johnson City, TNBuilt 1968 · S/N 28-24899N5559MBertelson Chester J · Modesto, CABuilt 1967 · S/N 096N5559PSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1958 · S/N 24-623N555AEaa Aviation Foundation Inc · Oshkosh, WIBuilt 1962 · S/N 1001N555AKBusy Bee Helicopter LLC · Paulding, OHBuilt 1993 · S/N 535N555AMEdgewater Ventures LLC · Friday Harbor, WABuilt 1978 · S/N 32R-7885187N555AWRamakrishna Murali DBA · Malden, MABuilt 2010 · S/N 536-2010N555AXWalsh David · North Platte, NEBuilt 2001 · S/N 9927CCN555AZN555az LLC · Herndon, VABuilt 1969 · S/N 28-26585N555BECrocker William D · Toledo, WABuilt 1973 · S/N 28R-7335254N555BJGypsy Aviation LLC · Newnan, GAS/N 182N555BNEmerald City Aircraft Leasing Inc · Port Orchard, WABuilt 2001 · S/N 1079N555CAFigueiredo William A · Riverside, CABuilt 1974 · S/N 28-7415139N555CCDavis Donel · Hollis, NYBuilt 1974 · S/N M-1589N555CVAviation Paradise LLC · Homestead, FLBuilt 1976 · S/N 17267112N555CWWolff Christine A Trustee · Aurora, COBuilt 1978 · S/N 1172N555CZGreenlawn Realty Co Inc · Columbus, OHS/N 18280325N555DCAmoroso Ricardo C · Powder Springs, GABuilt 1959 · S/N 23-1780N555DDBnc Aviation LLC · Georgetown, TXBuilt 1977 · S/N 177RG1122N555DKHorst Sheldon L · Columbia, PABuilt 1988 · S/N HOLMAN 0001N555DLSchaben Justin · Dunlap, IAS/N 32-7940103N555DNChapman Larry D · Avoca, IABuilt 2000 · S/N 22276
Back to AD 81-18-04 R2