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.

N2639VBowen 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 4496087N263BPederstuen Ricky L · Hudson, WIBuilt 1957 · S/N 23N263BCChambers William M · Elkmont, ALBuilt 2005 · S/N 9058N263BEEngen Burdell M · Viking, MNS/N 263N263MAMacair Aviation LLC · Xenia, OHBuilt 2004 · S/N 968-2004N263MGGeorgia Aviation Authority · Eastman, GABuilt 2020 · S/N 2881361N263NDPlane Nonsense Inc · Middletown, DEBuilt 1999 · S/N 2842064N26401Mann James R · Waikoloa, HIBuilt 1978 · S/N AA5A0565N26406Registration Pending · Valdosta, GARegistration pendingBuilt 1978 · S/N AA5A0568N26407Colvin Daniel A · Dayton, TNBuilt 1978 · S/N AA5A0569N2640MStraight Gary D · Wasilla, AKBuilt 1946 · S/N 12-982N2640PCrumley Emily M · Bristol, TNBuilt 1955 · S/N 22-2978N2640VBube Douglas G · Clarkston, WABuilt 1974 · S/N 177RG0640N26410Villanueva Francisco B · Leavenworth, KSBuilt 1978 · S/N AA5A0570N26411Cheetah LLC · Burlington, IABuilt 1978 · S/N AA5A0571N26412Pelican Fisheries Corp · Mount Pleasant, SCBuilt 1977 · S/N AA5A0493N26414Ambrose Douglas · Indio, CABuilt 1978 · S/N AA5A0578N26415Khano Maurice S · Kennesaw, GABuilt 1978 · S/N AA5A0579N2641AWhitcomb Glenn R · West Richland, WABuilt 1952 · S/N 22-910N2641MGeorge Gary D · Humble, TXBuilt 1946 · S/N 12-983N2641WRampini Daniel G · Cleveland, OHBuilt 1966 · S/N 3303N26422Cressey Aaron · Silverton, ORBuilt 1978 · S/N AA5A0582N26423Poulnott William · Milledgeville, GABuilt 1978 · S/N AA5A0583N26424Ormanian Austin · Canton, MIBuilt 1978 · S/N AA5A0584N26427She Runs I Fly LLC · Cincinnati, OHBuilt 1978 · S/N AA5A0585N2642DBurchard Farms LLC · Melber, KYBuilt 1988 · S/N 0820N2642MLons Travis W · King Salmon, AKBuilt 1946 · S/N 12-984N2642QLongerbone Danny L · Fishers, INBuilt 1970 · S/N 17258931N26439Warren John P · White Lake, MIBuilt 1940 · S/N 7617N2643VGorman Sean P · Superior, COBuilt 1974 · S/N 177RG0641N26440Nester Christopher J · Mount Washington, KYBuilt 1978 · S/N AA5A0591N2644MFaust Kevin C · Long Prairie, MNBuilt 1998 · S/N 23034N2644WMoran Robert D Jr · Plano, TXBuilt 1966 · S/N 979N26450Km Aero Inc · Kalispell, MTBuilt 1978 · S/N AA5A0596N26454Camarda Edward W · Conroe, TXBuilt 1978 · S/N AA5A0598N26456Coleman Edward H · Tulare, CABuilt 1978 · S/N AA5A0600N2645MSchwenke-Cram Kim · Madison, SDBuilt 1946 · S/N 12-979N2645QSigman Kenneth M · Birmingham, ALBuilt 1977 · S/N 28-7790411N26465Registered aircraftBuilt 1978 · S/N AA5A0612N2646MBelanger Bette · Wasilla, AKBuilt 1946 · S/N 12-1143N26471N26471 LLC · Versailles, KYBuilt 1978 · S/N AA5A0615N26479N24679 LLC · North Royalton, OHBuilt 1978 · S/N AA5A0619N2647PTrinkle Aviation LLC · Kingsburg, CABuilt 1955 · S/N 22-2985N26481Accessible Aviation Inc · Tupelo, MSBuilt 1998 · S/N 17280578N2648VWhite Jeffrey W · Macon, GABuilt 1974 · S/N 177RG0642N2648WDeghetto Richard D · Hopkinsville, KYBuilt 1966 · S/N 981
Back to AD 90-04-06 R1