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.

N7843RTrupkin Steven J · Wantagh, NYBuilt 1969 · S/N D-8918N7845RCurley Quinn T · Copperopolis, CABuilt 1968 · S/N D-8908N7846RLewis Paul Randell · Eastman, GABuilt 1969 · S/N TC-1205N7848REntrekin Gary W · Ventura, CABuilt 1968 · S/N D-8904N784AAHayden Charles J Jr · Richmond, TXBuilt 1961 · S/N D-6858N7850RShackelford John S Jr · Roanoke, TXBuilt 1969 · S/N TG-75N7853RHarrell Erick C · Sedona, AZS/N CJ-17N7856LGall Peter D · Morgantown, WVBuilt 1966 · S/N D-8289N7858PRegistered aircraftBuilt 1978 · S/N TJ-183N785DKFoxes Asset Group LLC · Caddo Mills, TXBuilt 1980 · S/N M-2250N785JBFuller Aire Inc · Wilmington, DEBuilt 1969 · S/N D-8915N785SRitchie Race Scott · Odessa, TXS/N EA-334N7865RSpangler Bryan G · Manteno, ILBuilt 1969 · S/N D-8932N7866RN7866r Leasing LLC · Linden, MIBuilt 1969 · S/N D-8926N7868LJacob William G · Glendora, CABuilt 1966 · S/N D-8292N7869LCrawford Scott · Newalla, OKBuilt 1966 · S/N D-8293N7869RRegistered aircraftBuilt 1969 · S/N TC-1209N786TSTurnquist Paul Sr · Lincoln, MEBuilt 1976 · S/N E-901N7870LCnf LLC · Ada, OKBuilt 1967 · S/N TE-336N7870REtchell Russell Allan Trustee · Santa Rosa, CABuilt 1969 · S/N D-8928N7873LMcguire David · Sandston, VABuilt 1966 · S/N TC-1018N7875LRegistered aircraftBuilt 1966 · S/N D-8295N7875RJohnson Joel Andrew · Winterset, IABuilt 1969 · S/N D-8934N7878RWeishaar Traig Tl · Worley, IDS/N TE-682N7878YKujanski Jon G Trustee · Saint Charles, ILBuilt 1991 · S/N CE-1563N7879LCjp Air LLC · Mustang, OKBuilt 1966 · S/N D-8318N7879RMorgan Mark T · Corryton, TNS/N D-8936N787DMoore Christopher R · Cape Coral, FLBuilt 1952 · S/N D-3056N787JKMark M Jackson Do LLC · Sarasota, FLS/N E-1159N787JVRegistered aircraftBuilt 1977 · S/N D-10082N787LLDouglas Aviation Ltd · South Barrington, ILS/N CE-1182N787MRMoon Aviation LLC · Oklahoma City, OKBuilt 1997 · S/N E-3144N787RMJohnson Plane Services · Greenbrier, TNBuilt 1993 · S/N CE-1719N787SCSilverthorne Adam · Walnut Creek, CABuilt 1962 · S/N DH-324N7880CSilvia Scott A · Valley Springs, CAS/N D-2742N7883LJinnette James G · Raleigh, NCBuilt 1966 · S/N D-8301N7885CS Tec Corp · Mineral Wells, TXBuilt 1966 · S/N TE-72N7885LGriffin Brad W · Salome, AZBuilt 1966 · S/N D-8303N7888SHangar One Lc · Clear Lake, IABuilt 1989 · S/N CE-1368N7889Missing Link Gravel LLC · Glasgow, MTBuilt 1949 · S/N D-2089N788DLSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1981 · S/N P-575N788KRegistered aircraftBuilt 1977 · S/N D-9992N7890RDanish Timothy F · Shreveport, LABuilt 1969 · S/N TG-76N7892RCutler Sewall C Jr · Fredericksburg, TXBuilt 1969 · S/N D-8944N7893LLilya Trever L · Mesa, AZBuilt 1966 · S/N D-8306N7894RMaul Russell L · Jacksonville, ILBuilt 1969 · S/N D-8946N7895LRemington Pierce S · De Kalb, MOS/N D-8297N789BWR&J Toy Fund LLC · Jefferson, SDBuilt 1967 · S/N TG-9N789CXDuke Boys LLC · North Sioux City, SDS/N TG-46N789DDrury Kevin S · Walker, LAS/N D-3058
Back to AD 99-05-13 R1 WD