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.

N133QFreeland Christopher G · Brownwood, TXBuilt 1957 · S/N D-5319N133SBColeman Terry Michael · Meridianville, ALS/N CE-891N133TDLanyi Clifford · Attleboro, MABuilt 1990 · S/N CE-1548N133VMCathey Gary C · El Dorado Hills, CAS/N CE786N134Mccann Thomas J Jr · Jackson, WYBuilt 1953 · S/N 53-4135N1340ZLogue Andrew Douglas Trustee · Port Saint Lucie, FLBuilt 1961 · S/N TD-474N1341VBischoff Roy H III · Flower Mound, TXS/N 6728N1341ZC A R Lease Corp Inc · Brentwood, TNBuilt 1961 · S/N TD-473N1343ZBriscoe Travis L · Archie, MOS/N D-6770N134ASmith Douglas O · Corvallis, ORFirst renewal noticeBuilt 1952 · S/N G-59N134AFSummerfield Douglas T · Mason City, IABuilt 1953 · S/N G-100N134BLOvaert Daniel L · Tryon, NCS/N BG-53N134CBGlobal Coin Logistics LLC · Lexington, KYBuilt 1967 · S/N TG-40N134CDL&L Aviation Inc · Advance, NCBuilt 1955 · S/N G-717N134DVac Sys Holdings LLC · Roseville, CAS/N G-743N134DHBohlig Stephen W · Minnetonka, MNBuilt 1953 · S/N 34-78N134DRRothenanger David A · Talladega, ALBuilt 1956 · S/N BG-169N134FLift Enterprises LLC · Lynn Haven, FLBuilt 1964 · S/N TC-816N134GLWhiskey Tango Aviation LLC · Owasso, OKBuilt 1955 · S/N G-732N134HRL&P Of Mke LLC · Milwaukee, WIBuilt 1955 · S/N G-745N134JCClark Julie E · Cameron Park, CAS/N G-812N134JVVance John C · Coleman, TXS/N BG-345DCN134KCKw Plastics · Troy, ALBuilt 1953 · S/N G-78N134LCConklin Lynn A · Vacaville, CABuilt 1953 · S/N 53-4149N134MBLarsen Matthew J · Filer, IDS/N G-83N134MDAa Aviation LLC · Lewes, DES/N TJ-449N134RHCarlton John B · Lenoir, NCS/N BG-31N134RRRussell Jon D · Calabasas, CABuilt 1957 · S/N BG-340N134SBBaksa Stephen D · Chatham, NJFirst renewal noticeS/N CN3N134SMCzech Six LLC · Lafayette, LABuilt 1957 · S/N BG-312N134TBKbld LLC · Buchanan, MIS/N HH-126N134TFSpectre Aviation LLC · Exeter, NHBuilt 1993 · S/N CE-1764N134TTPlane Fun Inc Tr Trustee · Snellville, GABuilt 1953 · S/N G-305N1351RN1351r Inc · Middletown, DEBuilt 1979 · S/N EA-21N1351ZErickson David R · West Point, UTS/N TC-148N1353RRegistered aircraftBuilt 1979 · S/N WA-6N1354ZGallo 12 LLC · Kalispell, MTBuilt 1961 · S/N D-6774N1355ZEnns Nathan G · Shafter, CABuilt 1961 · S/N D-6775N1357ZBromschwig Eric I · Montgomery, TXFirst renewal noticeS/N TC-157N135ABShreds Aircraft LLC · Pittsburgh, PABuilt 1957 · S/N D-5399N135BABemidji Aviation Services Inc · Bemidji, MNBuilt 1962 · S/N LD-68N135BEJeff Proctor Holding Lc · Park City, UTBuilt 1973 · S/N D-9524N135BWSteier James M · Omaha, NEBuilt 1984 · S/N CE-1044N135CEBell Strategic Investments Inc · Escondido, CAS/N CE-1356N135DWWagner Dennis L · Zionsville, INBuilt 1982 · S/N D-10399N135JAD & K Aviation Inc · Milford, IABuilt 1967 · S/N D-8478N135JLBurhoe Aaron D · Sonora, CABuilt 1955 · S/N D-4419N135KAcord Aviation Co L L C · Chandler, OKBuilt 1967 · S/N TD-691N135KCHerndon Cliffton R · Youngsville, NCBuilt 1972 · S/N CE-367N135PGKom Aviation LLC · Southern Pines, NCS/N D10394
Back to AD 99-05-13 R1 WD