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.

N7221BWood Douglas R · Renfrew, PABuilt 1958 · S/N D-5527N7222BSkans David K · Henderson, NVBuilt 1958 · S/N D-5544N7222H7222h LLC · Catlett, VABuilt 1984 · S/N E-2179N7222KBergambacht Aviation Inc · Dover, DEBuilt 1984 · S/N E-2164N7222LAllmon William C · Las Vegas, NVFirst renewal noticeS/N TJ-484N7224LRussell Jerald Trustee · Pampa, TXBuilt 1985 · S/N CE-1057N7224WMd Mcdonald Construction Co · Wilmington, DEBuilt 1985 · S/N E-2225N72253Big Smile LLC · Atlanta, GABuilt 1985 · S/N E-2227N7225CN7225c LLC · Plano, TXBuilt 1985 · S/N E-2226N7225HCosmo Plastics Company · Pepper Pike, OHBuilt 1985 · S/N TJ-485N7225MPeterson Bernard L · Bardstown, KYBuilt 1985 · S/N E-2282N7226BDelone Charles · Sarasota, FLS/N D-5549N7226KAgile Aviation LLC · Hilliard, OHBuilt 1985 · S/N CE-1058N7226MRolfe Glen · Holtville, CABuilt 1985 · S/N E-2228N7227BYoung Donald Stuart · Markham, VABuilt 1958 · S/N D-5660N7227UMartinson Medical Prof LLC · Sioux Falls, SDBuilt 1985 · S/N E-2231N7227WRr Salami LLC · Seguin, TXBuilt 1985 · S/N E-2232N72291Wandering Quarks LLC · Lincolnville, MEBuilt 1985 · S/N E-2247N72299Johnson James C · Marion, KYBuilt 1985 · S/N CE-1061N7229BManihuari Carlos A Ramos · Pittsburgh, PABuilt 1958 · S/N D-5542N7229XH&H Aviation Inc · Port Orange, FLBuilt 1985 · S/N CE-1063N722DRawls Steve · Fernandina Beach, FLBuilt 1951 · S/N D-2993N722FCostello Robert N · Ignacio, COBuilt 1966 · S/N M-981N722MDAnderson Richard E · Roanoke, VABuilt 1944 · S/N 6750N722PTj Air Holdings In Trustee · Wilmington, DEBuilt 1985 · S/N E-2219N722SPSky Aviation Inc · Sheridan, WYS/N D-6926N7230DJaspair LLC · Los Gatos, CABuilt 1985 · S/N E-2281N72311Qualitair LLC Trustee · MichelstadtBuilt 1985 · S/N CE-1062N72319Williams John I Jr · Jamaica Plain, MABuilt 1985 · S/N E-2245N7231BDendulk Arthur G Trustee · Hughson, CABuilt 1958 · S/N D-5540N7231EBoslo LLC · San Luis Obispo, CABuilt 1985 · S/N E-2240N7231RRegistered aircraftBuilt 1974 · S/N E-620N7231XFritsch William M · Terrell, TXBuilt 1986 · S/N E-2334N7232B7232b LLC · Grosse Ile, MIBuilt 1958 · S/N D-5562N7233BMason Phillip Ray · Jacksonville Beach, FLS/N D-5554N7233FTomlinson Avionics Of Florida Inc · Fort Myers, FLBuilt 1983 · S/N CE-1026N7233LBravo Foxtrot Zulu Holdings LLC · Unionville, CTBuilt 1984 · S/N CE-1049N72349Mjr Enterprises Inc · Eustis, FLBuilt 1985 · S/N E-2250N7234NBrazell Chad R · Guymon, OKBuilt 1985 · S/N E-2248N7235BPresley Tony L · Deridder, LAS/N D-5553N7235EContreras Patrick P · Marina Del Rey, CAS/N E-2252N7235HClover Crest II Inc · Key Largo, FLBuilt 1985 · S/N CE-1064N7235JZeve H Lincoln · Portland, ORBuilt 1985 · S/N E-2251N7235QH2f2 LLC · Prairie Village, KSBuilt 1984 · S/N CE-1035N7235YBarton Ferry Aviation LLC · West Point, MSBuilt 1985 · S/N E-2249N7236ARomero Ignacio · Miami Beach, FLBuilt 1984 · S/N E-2209N7236BLakey Robert E · Arlington, TXBuilt 1958 · S/N D-5564N7236WThomas Edward R · Piney Flats, TNBuilt 1984 · S/N E-2154N7237BBuhler Louis · San Francisco, CABuilt 1985 · S/N E-2255N7238LHorizon Flight Center LLC · Chesapeake, VABuilt 1981 · S/N ME-433
Back to AD 99-05-13 R1 WD