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.

N55CBBrown Gary M · Sioux City, IABuilt 1958 · S/N D-5714N55CDNy Properties LLC · Greenwood, SCBuilt 1963 · S/N D-7273N55CNBaron 55cn LLC · Haltom City, TXBuilt 1964 · S/N TC-601N55CVCavu LLC · Charleston, WVBuilt 1977 · S/N TE-1114N55CZHall William · Boynton Beach, FLBuilt 1976 · S/N TC-1932N55DBFletcher William J Trustee · Carson City, NVBuilt 1969 · S/N TE-716N55EWHanratty Brian James · Pismo Beach, CABuilt 1966 · S/N TD-681N55EZSummit Aviation Resources LLC · Akron, OHBuilt 1970 · S/N TE-785N55FDDieu Est Mon Courage LLC · Fernandina Beach, FLBuilt 1975 · S/N TC-1857N55HDNo Bad Days Consulting LLC · Frisco, TXBuilt 1977 · S/N TE-1089N55HMMoore Brian L · Reno, NVBuilt 1974 · S/N TC-1723N55JBHigh Point Management Co · Graford, TXBuilt 1990 · S/N CE-1493N55KMbi · Indn Hbr Bch, FLBuilt 1979 · S/N E-1601N55KCBloch Jeremy · San Francisco, CABuilt 1976 · S/N D-9930N55KJHope For Bethesda · Orange Park, FLBuilt 1977 · S/N TK-40N55KPJm Waypoint LLC · Fresno, CABuilt 1970 · S/N D-9173N55MLAlmeida Gabriel · Bellville, TXBuilt 1964 · S/N TC-691N55RABallard Almon B · Montgomery, ALBuilt 1967 · S/N TG-23N55RSCrop-Serv Inc · Meade, KSBuilt 1966 · S/N TE-151N55RVRegistration Pending · Dover, DERegistration pendingBuilt 1975 · S/N TC-1828N55STriple R Aviation LLC · Cleburne, TXBuilt 1965 · S/N TD-631N55SABemidji Aviation Services Inc · Bemidji, MNBuilt 1965 · S/N LD-243N55SEN55se LLC · Frankfort, ILBuilt 1968 · S/N TC-1136N55SGBas Part Sales LLC · Greeley, COBuilt 1976 · S/N TC-1955N55SJBk Air LLC · New Brighton, MNBuilt 1982 · S/N TC-2447N55SPJ&D Flying LLC · Clinton, MOBuilt 1966 · S/N D-8084N55SSMajane John A III · Germantown, MDBuilt 1955 · S/N D-4379N55TEMaxwell Aviation Inc · Chesterfield, MOFirst renewal noticeBuilt 1975 · S/N TC-1832N55TLRegistered aircraftBuilt 1976 · S/N TE-1079N55TSFlying Monkey LLC · Wilmington, DEBuilt 1961 · S/N TC-146N55TZBoswell Rick · Bartlesville, OKBuilt 1977 · S/N TE-1115N55VAHoward Alan L · Leeds, UTBuilt 1957 · S/N D-4996N55VBBregovlieger LLC · West Ossipee, NHBuilt 1975 · S/N TE-1072N55VEChilders Ranch LLC · Templeton, CABuilt 1965 · S/N D-7839N55VFTjp Aviation Inc · Garrettsville, OHBuilt 1978 · S/N TC-2132N55VGA And E Aero Ventures LLC · Saline, MIBuilt 1978 · S/N TC-2165N55VSSkie Flying Club LLC · Campbell, CAS/N CE-1305N55VTHardt Stefan M · Springfield, ORS/N D-4320N55WRussell Richard · San Jose, CAS/N D-1969N55WRNeumann Capital Holdings LLC · Bossier City, LABuilt 1965 · S/N D-7799N55WYCentury White Worldwide Inc · Casper, WYBuilt 1966 · S/N TE-241N55YBLockhart John E · Phoenix, AZBuilt 1967 · S/N TE304N55ZMAngel V LLC · Gig Harbor, WABuilt 1977 · S/N P-437N55ZZMaxson Lee V · Mesa, AZBuilt 1966 · S/N TE-133N5600KHurta Jennifer Nelsen · Cypress, TXBuilt 1964 · S/N D-7369N5601SArno Aero LLC · Merton, WIBuilt 1966 · S/N D-8152N5602SRegistered aircraftBuilt 1966 · S/N D-8153N5604KX-Country Ventures LLC · Usafa, COBuilt 1964 · S/N D-7459N5604SThrasher Luke DBA · Amarillo, TXBuilt 1966 · S/N D-8156N5605SDevereaux Saw Mill Inc · Pewamo, MIBuilt 1966 · S/N D-8319
Back to AD 99-05-13 R1 WD