OpenAirDocs.org
AD 99-05-13 R1 WD

Registered aircraft · 13,518

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

N3085FA To Z Endeavors LLC · Leawood, KSBuilt 1987 · S/N E-2396N3085KBennett Ross G · Eustis, FLBuilt 1987 · S/N E-2401N3085WFly Rudolf Corp · Wilmington, DEBuilt 1973 · S/N TE-954N3086CBlue Baron Fl LLC · Saint Cloud, FLS/N TE-510N3086KRicotta Tom · Yuma, AZBuilt 1988 · S/N E-2406N3088CMeester Daniel J · Longmont, COBuilt 1958 · S/N D-5773N3088DAquasol Corp · Rock Hill, SCBuilt 1987 · S/N E-2398N3089CWeatherly Richard A · Newport, WABuilt 1958 · S/N D-5772N3089HWilliamsburg Air Service Inc · Kingstree, SCBuilt 1988 · S/N CE-1219N3089ZSnyder Stephen F · Paradise Valley, AZBuilt 1987 · S/N E-2402N308ABLift Time III LLC · Cincinnati, OHS/N E-3533N308BClark Perry W · Pine River, MNBuilt 1954 · S/N CH-106N308BBCartwright James · Summerland Key, FLS/N TC-1886N308EShannon Jesse L · Boise City, OKS/N D-5763N3090PRegistered aircraftBuilt 1987 · S/N CE-1107N3092CAhmed Sharfaraz · Houston, TXBuilt 1959 · S/N D-5786N3092WPrimm Daniel D Jr · Lexington, KYBuilt 1973 · S/N D-9556N3094CHamllin Jeffry S · Double Oak, TXBuilt 1958 · S/N D-5783N3095CLittle Karley Y · Baytown, TXBuilt 1958 · S/N D-5774N3096CGrant Benjamin D · Chesterfield, MIBuilt 1958 · S/N D-5789N3096TBakamis Joel Alexander · South Lake Tahoe, CABuilt 1988 · S/N CE-1208N3096WPickering Paul S · Granbury, TXBuilt 1994 · S/N CE-1786N3097CAviation Hangar LLC · Wentzville, MOBuilt 1958 · S/N D-5787N3097WYarbrough G Mark · Sandia Park, NMBuilt 1973 · S/N CE-473N3099CTurpin Terry S · Foster City, CABuilt 1958 · S/N D-5782N3099WSavage Curtis Mac · Johnstown, OHBuilt 1973 · S/N D-9561N309BDavis Kaylee · Port Orange, FLBuilt 1956 · S/N D-4715N309DCRother Michael V · Granbury, TXBuilt 1979 · S/N D-10309N30AEKetting Case H · College Place, WABuilt 1962 · S/N JH-167N30CAState Of California Department Of Transportation · Sacramento, CABuilt 1974 · S/N CE-508N30CWBrownd Gregory H · Shallowater, TXBuilt 1958 · S/N D-5636N30DMNagle Derek · Ada, MIBuilt 1979 · S/N E-1536N30EBowker Mark S · Bowdoinham, MES/N D-2475N30EDN30ed LLC · Carpinteria, CABuilt 1969 · S/N D-9076N30GAg Air Inc · Matthews, MOBuilt 1946 · S/N A-131N30GBMission Air Aviation LLC · Roanoke, VABuilt 1964 · S/N BA-688N30HMHutchinson Brion M · Crowley, TXBuilt 1954 · S/N D-3853N30JVJasper Aviation Inc · Jasper, ALBuilt 1964 · S/N TD-597N30K9g LLC · Centerville, TNBuilt 1973 · S/N P-255N30KDHolmander John D · East Greenwich, RIS/N E-3502N30KJCrist Carry R · Crete, NEBuilt 1957 · S/N D-5181N30LFSignalwave LLC · Doral, FLBuilt 1980 · S/N EA-122N30LLSoftware Innovations LLC · Wahoo, NEBuilt 1982 · S/N TJ-391N30MJPrinter & Copier Guys LLC · Corona, CABuilt 1955 · S/N D-4343N30MKKelly Michael E · Cumberland, RIBuilt 1981 · S/N CE-989N30MMHilton Heli LLC · Wilmington, DEBuilt 1979 · S/N P-507N30PHStoneman Thomas K · Friendswood, TXS/N TJ-5N30RFBonsal John R · Flower Mound, TXBuilt 1978 · S/N CJ-142N30RMDaniel Warren · Naples, FLBuilt 1971 · S/N TE-828N30RPCommunications Laboratories Inc · Melbourne, FLBuilt 1982 · S/N E-2050
Back to AD 99-05-13 R1 WD