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.

N650THAri Ben Aviator Inc · Fort Pierce, FLBuilt 1982 · S/N ME-427N650VXOneal Timothy James · Vancouver, WABuilt 1967 · S/N MA-194N650YRWailea Aircraft LLC · Kamuela, HIBuilt 1981 · S/N E-1932N6510TLenkersdorfer John D · Burley, IDS/N MB-350N65118Stormy Pilots LLC · Saint Thomas, VIBuilt 1982 · S/N TJ-437N6511TAgricola Joseph D · Brooksville, FLBuilt 1968 · S/N MB-354N6513TReilly Michael G · Somerset, NJBuilt 1968 · S/N MB-355N6514RParker Scott L · Galatia, ILBuilt 1974 · S/N MB-711N6519NWinged Chariot LLC · Cincinnati, OHBuilt 1982 · S/N EA-319N6519RC & C Aeroventures LLC · Carson City, NVBuilt 1974 · S/N M-1542N6519TVeverka Merle G · Frederick, COBuilt 1968 · S/N MB-356N651BSjc IV LLC · Lawrence, KSBuilt 1949 · S/N A-478N651BBGooch Kelcy J · Ridgeland, MSBuilt 1950 · S/N D-2586N651TBrabant Charles A · Westminster, COBuilt 1963 · S/N TC-471N6521NPerkins Marcus · Ridgeville, SCBuilt 1982 · S/N MC-779N6525Sacramento Computer Power Inc · Sacramento, CABuilt 1977 · S/N E-1173N6525CRegistered aircraftBuilt 1961 · S/N D-6871N6527TBaugher Mark A · Harrison, MIS/N MB-359N65288Tammen Eric W · San Pedro, CABuilt 1983 · S/N E-2062N6528NMorgan John A · Katonah, NYBuilt 1982 · S/N M-2366N6529RN6529r LLC · Merritt Island, FLBuilt 1982 · S/N EA-322N652DMob Aviation USA LLC · Kissimmee, FLBuilt 1951 · S/N D-2919N652DBRocky Mountain Air LLC · Lafayette, COBuilt 1987 · S/N CE-1144N65318Prairie Sales Inc · Eden Prairie, MNBuilt 1983 · S/N E-2060N65320Lombardozzi James E · Billings, MTS/N EA-335N6535TDobson Richard W · Phenix City, ALBuilt 1968 · S/N MB-360N6536CWilliamson Michael A · Bend, ORBuilt 1983 · S/N MC-788N6536NPalmetto Wings LLC · Marietta, GAS/N E-2049N65376Sardella Craig J · Gold River, CABuilt 1983 · S/N EA-366N6538RFunnell John R · Cedar Park, TXBuilt 1974 · S/N MB-712N6539RSpencer Alexander Joshua · North Las Vegas, NVS/N MB-713N653DPrice Gary E · Cloverdale, CABuilt 1951 · S/N D-2920N653TCHomer Mark · Grosse Ile, MIBuilt 1964 · S/N TC-653N65420D5167 LLC · Kalispell, MTS/N E-2091N6544TCourtney John T · Woodbridge, CTBuilt 1968 · S/N MB-365N6544VHuber Robert T · West Chester, PABuilt 1983 · S/N E-2063N6545LBohn Martin · Lawton, OKS/N TC-679N6545RBonilla-Cruz Carlos · Houston, TXBuilt 1974 · S/N M-1581N6548CRobinetti Newbeard LLC · Stratford, CABuilt 1982 · S/N E-2051N654AJVintage Wings Aircraft LLC · Center Point, INBuilt 1964 · S/N D-7474N654BCannon Rick A · Langley, WABuilt 1948 · S/N D-1653N654DLinde Chase A · Sarasota, FLBuilt 1951 · S/N D-2921N654HRCoats James Michael · Murrieta, CAFirst renewal noticeBuilt 1959 · S/N D-5840N654JHEcho Bravo LLC · Helena, MTS/N E-3545N654SCLewis Aviation Inc · Wilmington, DEBuilt 1988 · S/N CE-1257N65503Bentz Andreas · Falls Church, VABuilt 1983 · S/N M2378N6551CChurch Thomas · Lenoir, NCS/N D-10402N6552VSatellite Airways Ltd · Pella, IABuilt 1967 · S/N D-8623N6552XRockdoc Investments LLC · Mckinney, TXBuilt 1983 · S/N EA-325N6553RRenkenberger Paul H · Yucaipa, CABuilt 1975 · S/N MB-744
Back to AD 99-05-13 R1 WD