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.

N5697KMerimont Aviation LLC · Dyersburg, TNBuilt 1964 · S/N D-7620N5698KSmith Ronald E · Jefferson, TXBuilt 1964 · S/N D-7622N5698SNewell Gary A · Colmar, PABuilt 1966 · S/N MA-102N5699KMoore Joseph M · Santa Barbara, CABuilt 1964 · S/N D-7603N56EEStansfield Tod A · Elm Grove, WIBuilt 1961 · S/N D-6703N56GFInternational Air Services Inc Trustee · Carson City, NVBuilt 1967 · S/N TG-29N56GLRainosek Kevin · Granbury, TXBuilt 1994 · S/N EA-572N56HMBarrett Keith Alan · Anniston, ALBuilt 1984 · S/N TJ-466N56JKStalp Ag Leasing LLC · Fremont, NES/N TC-1938N56JLSea Air Inc · Wilmington, DEBuilt 1977 · S/N D-10094N56NTJet Air Inc · Iowa City, IABuilt 1955 · S/N G-778N56TGTarcelo Francis Antonio G · Las Vegas, NVBuilt 1967 · S/N TG-37N56TMPoint Two Mmo Aviation · Lake Stevens, WABuilt 1961 · S/N TC-189N56VTColvin Clu DBA · Big Cabin, OKBuilt 1956 · S/N D-4506N56WHSteamboat Ridge LLC · Kaiser, MOBuilt 1967 · S/N D-8395N5700KNeel Aviation LLC · Lakeland, FLBuilt 1964 · S/N TC-702N5701VRuffcorn Aviation · Bettendort, IABuilt 1966 · S/N TE-89N5703KBean Billy R · Nashville, ARBuilt 1964 · S/N D-7511N5704VRon Eldridge Properties LLC · Nicholasville, KYBuilt 1966 · S/N D-8082N5706VMullin Sheryl M · Monroe, GABuilt 1966 · S/N D-8093N5707KCoeur Jeffrey James · Gulf Shores, ALBuilt 1964 · S/N D-7505N570SRobinson Michael D · Folkston, GABuilt 1969 · S/N TG-79N570TWilcox Robbie Craig · Smithville, MOBuilt 1961 · S/N D-6747N5710VOdell Stephen H · Thousand Oaks, CABuilt 1966 · S/N D-8087N5711VBrack-Ponce Annabelle S · Zephyr Cove, NVBuilt 1966 · S/N TE-95N5713KJennings James H · Clovis, NMBuilt 1964 · S/N D-7513N5713VCaribbean Dental Lab LLC · St Thomas, VIBuilt 1966 · S/N TE-98N5715KChase Brandon C · Plains, KSBuilt 1964 · S/N D-7510N5719KJohns Ricky · Joliet, ILBuilt 1964 · S/N D-7517N5719VFox Will E · Los Alamos, NMBuilt 1966 · S/N D-8092N571BPulis Ryan J · Spring, TXBuilt 1957 · S/N D-5397N571DDennis Billy C Jr · Scottsdale, AZBuilt 1975 · S/N TE-1030N571TIvey Martin J · Millsap, TXBuilt 1961 · S/N D-6754N571TXTravel Stiffs LLC · Madisonville, KYBuilt 1990 · S/N CE-1522N5720KCrumpler Chad C · Wichita, KSBuilt 1964 · S/N D-7520N5722KBranaman Timothy J · Monument, COBuilt 1964 · S/N TC-737N5724VN5724v LLC · Kalispell, MTBuilt 1966 · S/N D-8103N5726KRegistered aircraftBuilt 1964 · S/N D-7571N5727VCulver Investments LLC · Gordon, TXBuilt 1966 · S/N D-8186N572BPThomas Andy K · Cary, NCBuilt 1983 · S/N CE-1019N572TPaterson Eric G · Blacksburg, VABuilt 1964 · S/N D-7400N572TMJohnson Eric N · Port Matilda, PABuilt 1984 · S/N E-2125N5730VBooher Tabitha O · Livingston, TNBuilt 1966 · S/N D-8101N5731VBig Bend Community College · Moses Lakes, WABuilt 1966 · S/N TD-652N5732KAndrus Ralph · Denison, TXBuilt 1964 · S/N D-7518N5732VErps Jason D · Blue Springs, MOBuilt 1966 · S/N D-8104N5734BGrinnell Chris · Willis, TXBuilt 1956 · S/N BG-365N5736VLom-Ajan Vicente A · Plantation, FLS/N D-8105N5737KNeubauer Accounting LLC · Wray, COBuilt 1964 · S/N D-7540N5738VBailey Frederick D · Fayetteville, ARBuilt 1966 · S/N D-8109
Back to AD 99-05-13 R1 WD