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.

N52WRCoppola Larry Joe · West Des Moines, IAS/N D-4841N5300BPerkins Dimmitt · Sheridan, ARS/N D-3597N5300PMrozinski Robyn K · Hugo, MNS/N M-1628N5307EHutton Douglas F · Elk City, OKBuilt 1958 · S/N D-5766N530CContinental Title Trust LLC Trustee · Wichita, KSBuilt 1976 · S/N D-9927N530MOsteen Robert S · Port Saint Lucie, FLBuilt 1964 · S/N TC-687N531Martz G Rodney · Frederick, MDBuilt 1953 · S/N D-3676N5311ESale Reported · Playa Del Rey, CASale reportedBuilt 1958 · S/N D-5775N5313EFlying And Farming LLC · Kingsley, IABuilt 1959 · S/N D-5844N5316ENoble Zachary Q · Rhoadesville, VABuilt 1959 · S/N D-5813N5317ECallaghan James J III · West Chester, PABuilt 1959 · S/N D-5808N5319EKing Mark B · Lewisville, TXS/N D-5878N531ABMissionair Inc · Danbury, CTS/N TJ-454N531ALClark Terry W · Palmer, AKS/N D-6062N531BFLouis F Olberding Dds Pc · Lincoln, NEBuilt 1973 · S/N D-9541N531QRegistered aircraftBuilt 1968 · S/N TC-1141N531UArizona Air Transport LLC · Mesa, AZBuilt 1966 · S/N TE-104N5320Barnett Mike · Jacksonville, FLBuilt 1961 · S/N TD-452N5322EBlackwell Aviation Inc · Rostraver Township, PABuilt 1959 · S/N D-5806N5324EFox James M · Centreville, VABuilt 1959 · S/N D-5819N5325EThese Knots Aviation LLC · Bullard, TXBuilt 1959 · S/N D-5820N5326ESpiegel Jacob · San Francisco, CABuilt 1959 · S/N D-5868N5327EStone Robert T Trustee · Brookville, OHBuilt 1958 · S/N D-5792N53298Shatz Randy · Prescott, AZBuilt 1943 · S/N 4900N532BWeinreich Mark W · River Falls, WIBuilt 1948 · S/N D-1547N532CHall Brian · Yuma, AZBuilt 2002 · S/N EA-691N532EBlue Pointe Aviation LLC · Valparaiso, INBuilt 1989 · S/N CE-1377N532GMsd Sales Inc · Cedar Rapids, IABuilt 1977 · S/N E-1038N532QRoush James L · Medina, WABuilt 1968 · S/N TC-1160N532TBosse Don R · Bellville, TXS/N D-6598N5331EMangum Contracting Inc · El Dorado, ARBuilt 1959 · S/N D-5807N5333EBeech Bums LLC · Brookings, SDBuilt 1959 · S/N D-5824N5334ESchroeder Deon E · Vancouver, WABuilt 1959 · S/N D-5798N5335BDarter Lloyd R · Slater, IAS/N D-7161N5336ENorthstar Ministries Inc · Fairbanks, AKBuilt 1959 · S/N D-5830N5339ENbc Investments Ltd · Granbury, TXFirst renewal noticeBuilt 1959 · S/N D-5822N533C71sq Inc · Wilmington, DEBuilt 1978 · S/N CJ135N533SZilz Tammy S · Saint Peters, MOBuilt 1965 · S/N D-8028N533XRegistered aircraftBuilt 1985 · S/N E-2234N5341EKatz-Braunschweig Daniel A · Staten Island, NYBuilt 1959 · S/N D-5795N5342EJenkins Douglas III · Lancaster, CABuilt 1959 · S/N D-5804N5347EShashikanth Srinivas · Birmingham, ALBuilt 1959 · S/N D-5851N5347WAmerican Airpower Heritage Flying Museum · Dallas, TXBuilt 1955 · S/N G275N5349B39 Bravo LLC · Wilmington, DEBuilt 1988 · S/N E-2416N5349EHutchison Herbert IV · Wichita, KSBuilt 1959 · S/N D-5831N534BWBilmar Avionics Inc · Kissimmee, FLS/N G-63N534CBZahler Steven E · Manning, SCBuilt 1953 · S/N 53-4154AN534DBBerry Darrel · Camden, TNBuilt 1958 · S/N CG-207N534EGilday Aviation LLC · West Harrison, INS/N D-7825N534QKenney Aviation LLC · Osterburg, PABuilt 1968 · S/N TC-1176
Back to AD 99-05-13 R1 WD