OpenAirDocs.org
AD 90-04-06 R1

Registered aircraft · 68,369

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:90-04-06-R1')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:90-04-06-R1')
  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.

N262TBarnstormers Aerial Advertising LLC · North Myrtle Beach, SCBuilt 1953 · S/N 18-2376N262XPrice Scott K · Sparks, MDBuilt 1973 · S/N 28R-7335286N26300Boyer Steven L · Wooster, OHBuilt 1977 · S/N AA5A0513N26304Cobra Kai Inc · Wichita Falls, TXBuilt 1977 · S/N AA5A0522N2630MMock Air LLC · Marion, INBuilt 1979 · S/N 17271166N2630UShaka Skies LLC · Kihei, HIBuilt 1998 · S/N 17280568N2630VAgue Curtis M · Kailua, HIBuilt 1974 · S/N 177RG0636N26314Allen James R · Glasgow, KYBuilt 1978 · S/N AA5A0529N26315Graham Craig W · Anacortes, WABuilt 1940 · S/N LA-7810N2631AHarper Clayton E · Seabrook, TXBuilt 1952 · S/N 22-903N2631PFriebel Mark A · Shelby, OHBuilt 1955 · S/N 22-2968N2631WPlanes & Parts Inc · Weston, FLBuilt 1966 · S/N 3299N26321Southern Arkansas University Tech · East Camden, ARBuilt 1940 · S/N L-7850N26323Peachtree Builders LLC · Waterford, NYS/N AA5A0534N26328Gilbert James D · Kansas City, KSBuilt 1940 · S/N L7940N26329Bennett Ronald J · Houston, TXBuilt 1940 · S/N L-7950N2632JDevries 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-905N26349Bonnell 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 AA5A0541N2635PSchuller 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 AA5A0544N26377Petersen Tim G · Cambridge, NES/N L8410N26379Wings 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 AA5A0562N2639MPense Douglas H · Fairbanks, AKBuilt 1946 · S/N 12-977
Back to AD 90-04-06 R1