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.

N8969MTriple Heaven Aircraft Leasing Inc · Anchorage, AKBuilt 1964 · S/N TC-561N896TBcp Aero Operations LLC · Alpharetta, GAFirst renewal noticeBuilt 1989 · S/N CE-1341N8970AKelley Con A · Green Cove Springs, FLS/N D-2724N8970MAviator Air Flight School LLC · Grand Prairie, TXBuilt 1964 · S/N TC-594N8979MBean George W Jr · Fort Worth, TXBuilt 1964 · S/N TD-564N897SBCascade Airways LLC · Jefferson, ORBuilt 1958 · S/N BA-385N897TRegistered aircraftBuilt 1972 · S/N D-9354N897TMLow Approach Only LLC · Wilmington, DEBuilt 1965 · S/N D-7962N8981MPeter N Steinmetz Trustee · Tempe, AZBuilt 1964 · S/N D-7339N8982MSharman Paul D · Carefree, AZBuilt 1964 · S/N D-7310N8983AStark Erik K · Frisco, TXBuilt 1951 · S/N D-2735N8986AHickman Herbert A · Fullerton, CABuilt 1951 · S/N D-2738N8986M170kts LLC · Novato, CABuilt 1964 · S/N D-7313N898DMMeis David Bradley · Belmont, NCS/N E-3216N898JBSalesapproach Inc · Marlborough, MABuilt 1975 · S/N E-704N898QCrosby John J · Adel, GABuilt 1953 · S/N D-3511N898WPTriple B Aviation Inc · Idabel, OKBuilt 1990 · S/N CE-1513N8990MHayden Patrick Jr · Lexington, KYBuilt 1964 · S/N D-7312N8991AStikekeather Caro Anne · Arlington, VAS/N D-2743N8991MHilgy'S Aviation LLC · Tomahawk, WIBuilt 1965 · S/N TC-937N8993MNorthwood Holdings LLC · Dugspur, VABuilt 1964 · S/N D-7316N8995MCollins Sherman C · Sedona, AZBuilt 1964 · S/N D-7317N8996ACzerski Norman B · Eagle River, AKBuilt 1951 · S/N D-2748N899AVGilbert Charles L · Belleair, FLBuilt 1980 · S/N ME-353N899RBRoach John H · North Salem, NYBuilt 1976 · S/N CE634N899TEtherington Charles A Trustee · Vlg Loch Loyd, MOBuilt 1971 · S/N D-9297N89AUAllen Esta Ross III · Houston, TXBuilt 1987 · S/N CE-1129N89EDPage Daniel R · Raleigh, NCBuilt 1979 · S/N E-1479N89GTMinasian Paul Ryan Trustee · Oroville, CABuilt 1989 · S/N CE-1383N89JBEspelien Jay A · Sartell, MNBuilt 1981 · S/N M-2242N89JSPh Flight Services LLC · Wilmington, DEBuilt 1967 · S/N D-8537N89KBJet Sense Aviation Aircraft Holdings Corp · Burlington, WIS/N EA-54N89LRA36 Gps LLC · Boone, NCBuilt 1982 · S/N E-2058N89LSCals Ltd · Harbor Springs, MIBuilt 1991 · S/N CE-1583N89PDCaleta Ventures LLC · Richmond, TXBuilt 1979 · S/N E-1554N89SGHatch Christopher L · Harpswell, MEBuilt 1989 · S/N CE-1357N89ZMDx Aviation LLC · Broken Arrow, OKBuilt 1989 · S/N CE-1413N8ADChelsea Build LLC · Brenham, TXS/N EA-359N8BULakeair LLC · Richland, MIBuilt 1970 · S/N TC-1322N8BYTarrant County College District · Fort Worth, TXBuilt 1977 · S/N P-452N8FJCheap Thrills I LLC · Salida, COBuilt 1969 · S/N E-187N8FMSky Dawg LLC · Winterville, NCBuilt 1997 · S/N E-3068N8GMWalker Bobbie R · Denver, COBuilt 1954 · S/N D-3943N8HXTwin Bridges Aero LLC · Itasca, ILBuilt 1955 · S/N BG-104N8KWSigurdson Richard J · Olivia, MNBuilt 1977 · S/N D-10091N8MPForeman Thomas H · Orange, TXBuilt 1966 · S/N D-8059N8MWHeckler Gary C · Carefree, AZBuilt 1976 · S/N D-9943N8NDSmith Dane S · Berlin Heights, OHBuilt 1971 · S/N MB-514N8PEEdwards Pacific Aviation Corp · Dover, DEBuilt 1980 · S/N P-540N8RBMckeen John C · Santa Clarita, CABuilt 1966 · S/N TD-662
Back to AD 99-05-13 R1 WD