OpenAirDocs.org
AD 81-18-04 R2

Registered aircraft · 81,728

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.

N2630VAgue Curtis M · Kailua, HIBuilt 1974 · S/N 177RG0636N26314Allen James R · Glasgow, KYBuilt 1978 · S/N AA5A0529N2631AHarper Clayton E · Seabrook, TXBuilt 1952 · S/N 22-903N2631CAndrews John M · Titusville, FLBuilt 1978 · S/N R18200183N2631PFriebel Mark A · Shelby, OHBuilt 1955 · S/N 22-2968N2631WPlanes & Parts Inc · Weston, FLBuilt 1966 · S/N 3299N26323Peachtree Builders LLC · Waterford, NYS/N AA5A0534N2632CSheldon Benjamin Lloyd · Duck Creek Village, UTBuilt 1978 · S/N R18200184N2632JDevries Mark R · Eagle River, AKBuilt 1957 · S/N 18-5858N2632WKrapp Transfer · Jamestown, NDBuilt 1966 · S/N 3300N2632YAtp Aircraft 4 LLC · Wilmington, DEBuilt 1998 · S/N 17280570N26330Davis Timothy Scott · Lexington Park, MDBuilt 1978 · S/N AA5A0536N26334Mullins Donald · Pounding Mill, VAS/N AA5A0537N26337Munson Andreas C · Seattle, WABuilt 1978 · S/N AA5A0538N2633AReich Dan E · Walla Walla, WABuilt 1952 · S/N 22-905N2633CWalusz Bernice J · Linden, NJS/N R18200185N26349Bonnell Corey K · Waxahachie, TXBuilt 1978 · S/N AA5A0540N2634EAzul Services LLC · Bozeman, MTBuilt 1998 · S/N 17280572N2634GDavis Michael W · Richland, WABuilt 1967 · S/N 476N2634MN2634mm LLC · Farmingdale, NYBuilt 1977 · S/N 28-7816298N2634RRichardson Michael T · Inver Grove Hghts, MNS/N 28R-35236N2634WGuerrero Aircraft LLC · Newport, WABuilt 1966 · S/N 973N26353Scoggin Gerald W III · Port Saint Lucie, FLS/N AA5A0541N2635CMason Gregory J · Rice Lake, WIBuilt 1978 · S/N R18200186N2635PSchuller Henry Michael · Arlington, WABuilt 1955 · S/N 22-2973N2635QAir-Mods Flight Academy · Robbinsville, NJBuilt 1977 · S/N 28-7716115N2635WElam Brent R · Woodford, VABuilt 1966 · S/N 974N26360Stickney John M · Chapin, SCBuilt 1978 · S/N AA5A0543N26368Parker Dennis A · Charlevoix, MIBuilt 1978 · S/N AA5A0544N2636CSexton David Lee · Barnesville, GABuilt 1978 · S/N R18200187N26379Wings Over Texas Holdings LLC · Denton, TXBuilt 1998 · S/N 17280573N2637PMurray James A · Wasilla, AKBuilt 1955 · S/N 22-2975N2637WCox James L · Fort Worth, TXBuilt 1966 · S/N 3302N26380Downey Matthew R · Colorado Springs, COBuilt 1977 · S/N AA5A0404N26384Farley Robert W · Warwick, MABuilt 1978 · S/N AA5A0553N26385Emerald City Aircraft Leasing Inc · Port Orchard, WABuilt 1988 · S/N 0804N26387Masco Howard N · Huntsville, ALBuilt 1978 · S/N AA5A0555N26389Wilson Billy Joe · Granite Falls, NCBuilt 1978 · S/N AA5A0556N2638MBooth Wade W · Palmer, AKBuilt 1946 · S/N 12-981N2638VWells Larry C · Flowood, MSBuilt 1974 · S/N 177RG0638N26390Rucker Roger D · Pembroke Pines, FLBuilt 1978 · S/N AA5A0557N26396Vergona John T · Canton, MIBuilt 1978 · S/N AA5A0561N26398Fenton David W · Kihei, HIBuilt 1978 · S/N AA5A0562N2639CClear And Seven LLC · Santa Teresa, NMBuilt 1978 · S/N R18200189N2639MPense Douglas H · Fairbanks, AKBuilt 1946 · S/N 12-977N2639VBowen Keith S · Lyle, WABuilt 1974 · S/N 177RG0639N2639WBrown Jeffrey R · Leesburg, FLBuilt 1966 · S/N 976N263ALEvans Randall B Trustee · Fallon, NVBuilt 2007 · S/N 2426N263AMCarmichael Joel E · Greensboro, NCS/N 20-1049N263ATAirline Transport Professionals Corp Of USA · Wilmington, DEBuilt 2001 · S/N 4496087
Back to AD 81-18-04 R2