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.

N517HAHarrison Aviation LLC · Macon, GABuilt 1984 · S/N E-2175N517JLSchmidt Robert G · Coppell, TXBuilt 1958 · S/N D-5762N517KGRegistration Pending · Pittsburg, TXRegistration pendingBuilt 1980 · S/N D10350N517PYYoung Millard Perrin · Raleigh, NCBuilt 1970 · S/N CE-305N518Action Aviation Inc · New Port Richey, FLBuilt 1953 · S/N D-3636N5183MGc Aviation Services 1 LLC · Miamisburg, OHBuilt 1978 · S/N ME-13N5186CGreiman George M · Garner, IABuilt 1950 · S/N D-2468N5188CMagnuson Waldo G Jr · Spokane, WABuilt 1950 · S/N D-2470N518ABVickery Hawk Partners LLC · Fort Worth, TXBuilt 1974 · S/N CE-518N518APWilliams Brian K · Mattituck, NYS/N M-1869N518MMull Jason E · Chester, NYBuilt 1970 · S/N D-9111N518PRodney H Greenway Inc · Niceville, FLS/N E-3483N518QLab Aviation Corp · Montville, NJBuilt 1967 · S/N TC-1038N518TJJohnson Travis · Wright City, MOBuilt 1972 · S/N TC-1436N518YPWs Aviation Group LLC · Washta, IABuilt 1980 · S/N TJ-265N5191CWeeks Benjamin D · Highlandville, MOBuilt 1950 · S/N D-2473N5194MSunstate Aviation Inc · Kissimmee, FLBuilt 1978 · S/N ME-17N51969Culpepper Matt D · Las Vegas, NVS/N 4898N5196CBurnham Kenneth J · Carr, COS/N D-2478N5198CR & S Enterprises · Fort Wayne, INBuilt 1950 · S/N D-2480N5199CWhisanant Bob · Winnett, MTBuilt 1950 · S/N D-2481N519BGAir Transportation Alternatives LLC · Carmichael, CABuilt 1980 · S/N TC-2321N519CMCygnet Aerospace Corp · Los Osos, CAS/N TJ-56N519DJKessler Nicholas R · Central Point, ORBuilt 1977 · S/N TC-2030N519JMWolfgang James · Milledgeville, GABuilt 1978 · S/N MC-634N519PHFlyboys LLC · Blue Bell, PABuilt 1957 · S/N D-5413N519RRothacker Aviation LLC · Wilmington, DEBuilt 1986 · S/N CE-1083N51ALGalaxy Cerne LLC · Burlington, VTBuilt 1973 · S/N P-247N51CCCreekview Corporation · Orlando, FLBuilt 1978 · S/N TC-2131N51CLDocs Flight Training LLC · Prescott, AZBuilt 1974 · S/N P-260N51ECVesely & Co Inc · Houston, TXBuilt 1995 · S/N E-2983N51EDWallbirds LLC · San Diego, CABuilt 1955 · S/N D-4246N51HMDw Peterson Inc · Warren, MNBuilt 1966 · S/N D-8288N51KAA & L Farm Services Inc · Helena, ARBuilt 1977 · S/N TC-2099N51KPShoreline Aviation LLC · Waco, TXS/N P-368N51MAAch Construction & Properties LLC · Mount Pleasant, TXBuilt 1978 · S/N E-1230N51MLTrek Aviation LLC · Amsterdam, NYBuilt 1997 · S/N E-3105N51MMStripe Joseph R · Olympia, WAS/N 4886N51PVCrupi John · Fort Lauderdale, FLBuilt 1987 · S/N CE-1174N51RJJones Robert B Trustee · Fresno, CABuilt 1960 · S/N D-6371N51TTThumann Wayne E · Weimar, TXFirst renewal noticeBuilt 1981 · S/N BG-107N51WAPennewell Solutions LLC · Dover, DEBuilt 1973 · S/N CE-452N51WP79ef LLC · Granite Falls, MNBuilt 2003 · S/N E-3508N51YDTj Air Holdings Inc Trustee · Wilmington, DES/N CE-867N5202CJames Joe T · Brownsville, ORBuilt 1950 · S/N D-2547N5203CPlane Fun Inc Tr Trustee · Snellville, GABuilt 1950 · S/N D-2548N5204CPeace Sign LLC · Bozeman, MTBuilt 1950 · S/N D-2549N5204MZenteno Nelson Jr · Winter Haven, FLBuilt 1978 · S/N MB-878N5206COnderdonk William A III · Spring Branch, TXBuilt 1950 · S/N D-2551N520PKJol Av Inc · Orange Beach, ALBuilt 2000 · S/N E-3365
Back to AD 99-05-13 R1 WD