AD 96-10-01 R1

Registered aircraft · 8,139

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:96-10-01-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:96-10-01-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.

N56704Anderson Aviation LLC · Wadesboro, NCFirst renewal noticeBuilt 1973 · S/N 28-7425021N56705Syrek William · Erie, PABuilt 1973 · S/N 28-7425022N5670UNelson Bros Farms · Hector, MNS/N 28-26467N56713Vaillancourt Marc H · Milford, MABuilt 1973 · S/N 28-7425023N56714Richman Martin S Trustee · Leawood, KSBuilt 1973 · S/N 28-7425024N56717Hp Flight Service LLC · San Antonio, TXBuilt 1973 · S/N 28-7405028N56723Sewell David J · Largo, FLBuilt 1973 · S/N 28-7425025N56724Marianas Air Transfer Inc · Tinian, MPBuilt 1973 · S/N 28-7425026N5672UWatson Phillip J · Jackson, TNBuilt 1969 · S/N 28-26469N56734Hales Michael G · Farwell, MIBuilt 1973 · S/N 28-7425028N56736N56736 LLC · Fort Smith, ARBuilt 1973 · S/N 28-7405029N56748Cutler Matthew · Santa Clarita, CAS/N 28-7425029N5674WJimenez Marcos A · Little Ferry, NJBuilt 1962 · S/N 28-868N56750Williams Nicholas E K · Stacy, MNFirst renewal noticeBuilt 1973 · S/N 28-7425030N56756Morley Thomas O · Riverside, CAS/N 28-7425031N5675WAmmons Benjamin W Jr · Jacksonville, FLBuilt 1962 · S/N 28-898N5676UMg Aviation · Oshkosh, WIBuilt 1969 · S/N 28-26473N56771Haight Robert A · East Haven, CTBuilt 1973 · S/N 28-7425032N5677UGolden Age Aviation LLC · Naperville, ILBuilt 1969 · S/N 28-26474N5677WLangel Brandon · Saint Charles, MOS/N 28-909N56783Dennerline Rhett R · Northfield, ILBuilt 1973 · S/N 28-7425035N56788Osgood Aaron · Glen Mills, PABuilt 1973 · S/N 28-7405031N5678UPaul William R · Oconomowoc, WIBuilt 1969 · S/N 28-26475N5678WMckinney Douglas Andrew · Hastings, MNBuilt 1963 · S/N 28-913N5679UInverted Holdings LLC · Newnan, GABuilt 1969 · S/N 28-26476N56809Hudak Susanne Marie · Gold Canyon, AZS/N 28-7425041N5680WGoines Courtnee J · Jacksonville, FLS/N 28-931N56821Cowlin Aviation LLC · Houston, TXBuilt 1973 · S/N 28-7425046N56828Gillette Daniel R · Chillicothe, ILBuilt 1973 · S/N 28-7425048N5682WRiggin Flight Service Inc · Madison, SDBuilt 1962 · S/N 28-938N5683WYanta Chris · Rockport, TXBuilt 1962 · S/N 28-940N5684WSeverino Racli · Closter, NJBuilt 1963 · S/N 28-948N5685UTres Amigos Flying Club LLC · Redding, CABuilt 1969 · S/N 28-26482N5685WRempel Steven P · Prague, OKBuilt 1962 · S/N 28-953N56861Wingsleasing LLC · Wichita, KSBuilt 1973 · S/N 28-7405035N5686UHobbs Stanley T · Middleburg, FLBuilt 1969 · S/N 28-26483N5686WPromedical Inc · Pfafftown, NCBuilt 1962 · S/N 28-954N56887Leavitt Teyvin M · Coeur D Alene, IDS/N 28-7425059N5688WSerendipity Rentals LLC · Denver, COBuilt 1963 · S/N 28-1013N56898Evans Katrina · Watkinsville, GABuilt 1973 · S/N 28-7425061N5689UGeorge Marc J · Harker Heights, TXBuilt 1969 · S/N 28-26486N568FLAir Ventures Flying School LLC · Smithfield, RIBuilt 1971 · S/N 28-7125411N568WACarver Clarence K Trustee · Lutz, FLS/N 28-7325162N56902G R Martin & Associates LLC · West Plains, MOS/N 28-7405037N5690UPena Flight Partners LLC · Oakland, CABuilt 1970 · S/N 28-26488N5690WSaunders Sean D · Smyrna, TNS/N 28-1032N5692WFollmer Harvey C III · Trout Run, PABuilt 1963 · S/N 28-1045N56943Mcdowell David M · El Cajon, CABuilt 1973 · S/N 28-7425066N5694UPlencner Robert E · Round Lake Beach, ILBuilt 1969 · S/N 28-26491N5694WLange James R · Tempe, AZBuilt 1963 · S/N 28-1060
Back to AD 96-10-01 R1