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.

N857CGRbf Partners LLC · Chattanooga, TNS/N E-1128N8580RHabanero One Express Inc · Ann Arbor, MIBuilt 1974 · S/N TC-1771N8583RFresa Oro Inc · Carlsbad, CABuilt 1974 · S/N CE-538N8584RRjm Aero Inc · Fallbrook, CABuilt 1974 · S/N CE-539N8585AFervida Jeffrey B · Milford, INBuilt 1949 · S/N D-2007N8585RLaminar Capital Ventures LLC · Sheridan, WYBuilt 1974 · S/N P-282N8586MNahas Andrew W · Viroqua, WIBuilt 1963 · S/N D-7222N8586RRj Sprik Aviation Services LLC · La Porte, INFirst renewal noticeBuilt 1974 · S/N CE-540N8588AAbbott R Barry · Tempe, AZBuilt 1949 · S/N D-2010N8588MHoward Richard · Erie, COBuilt 1963 · S/N D-7224N8589ABravo Tango LLC · Indianapolis, INBuilt 1949 · S/N B-18N8589MOwosso Aircraft LLC · Bancroft, MIExpired dealerBuilt 1963 · S/N D-7233N8589RRegistered aircraftBuilt 1974 · S/N TC-1775N858ALFinnegan Brian · Novato, CABuilt 1990 · S/N E2544N858DFulmer Robert Alan · Irvine, CABuilt 1966 · S/N D-8200N858JMDebergalis Matt · San Francisco, CABuilt 1965 · S/N TE-17N858KFox Powder LLC · Wilmington, DEBuilt 1981 · S/N P-574N858MLLang Inc · Wilmington, DEBuilt 1980 · S/N TJ-257N858PTj-128 LLC · Dover, DES/N TJ-128N858TCH2 Transportation LLC · Macon, GABuilt 1979 · S/N TK-98N8590MLeaders Chase N · Clear Lake, MNS/N D-7293N8591MPreszler Terence H · Braddock, NDBuilt 1963 · S/N D-7225N8592MWeis Samuel K · Madera, CABuilt 1963 · S/N D-7226N8595ANorthshore Flyers · Houston, TXBuilt 1949 · S/N D-2033N8595MMohle Darren · Carlsbad, CABuilt 1963 · S/N TD-535N8596RTjh Aviation · Greenville, TXBuilt 1974 · S/N TC-1780N8598MMerrill Gregory T · Fresno, CABuilt 1963 · S/N D-7228N859CBoe Ndt LLC · Haysville, KSBuilt 2001 · S/N E-3395N85BAMclean Randy Justin · Taylorsville, NCBuilt 1968 · S/N D-8820N85BBAvanti Aviation LLC · Bellevue, NEBuilt 1973 · S/N E-508N85BWSayler Nathan T · Valley City, NDBuilt 1961 · S/N TD-480N85CMRuggles Don C · Texarkana, ARS/N TC-1092N85ECHammett Wilbur Jeffrey · Saint Augustine, FLBuilt 1985 · S/N E-2278N85GSMtas LLC · Laveen, AZS/N D-3627N85JLewis Thomas R · Aransas Pass, TXBuilt 1954 · S/N D-3774N85JS85 Juliet Sierra LLC · Chico, CABuilt 1970 · S/N CE-303N85MCFrasier Samuel R · Gainesville, FLS/N DH-79N85MEGlobal Petroleum Services LLC · Greenville, SCBuilt 1978 · S/N TJ-168N85SXBaker Kenneth L Jr · Carlisle, KYBuilt 1958 · S/N D-5605N85TMErwin Matthew Lee · Georgetown, INBuilt 1957 · S/N EH-8N85WMDiaz Oscar Jr · Raleigh, NCBuilt 1981 · S/N CE-943N8600QSpano Darren · Deville, LABuilt 1964 · S/N D-7630N8602AHardcopf Robert W · Apple Valley, MNBuilt 1949 · S/N D-1989N8602MP35 Bonanza LLC · Dequincy, LABuilt 1963 · S/N D-7294N8602QMarker Richard A · Healdsburg, CABuilt 1964 · S/N D-7633N8603QHolland Jeffrey R · New Canaan, CTBuilt 1964 · S/N D-7634N8604MLemrick Landon · Colton, ORS/N D-7229N8604QPearson John P · Pueblo, COBuilt 1964 · S/N D-7635N8605ADifferent Auto LLC · Twin Falls, IDBuilt 1948 · S/N D-1928N8609MHodde & Hodde Land Surveying Inc · Brenham, TXBuilt 1963 · S/N D-7236
Back to AD 99-05-13 R1 WD