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.

N4616DBrockman Steven C · Seattle, WABuilt 1956 · S/N D-4784N4618MBedrock Siteworks LLC · Coatesville, PABuilt 1978 · S/N TJ-150N4619DBovee Timothy L · Wenatchee, WAFirst renewal noticeBuilt 1956 · S/N D-4780N461AJohnson James Michael · Mount Pleasant, SCBuilt 1967 · S/N D-8392N461BNottingham Jeff · Fuquay Varina, NCBuilt 1948 · S/N D-1631N461DAGrave Eugene G · Spencer, INS/N D-8572N461SSRodie James S · Vero Beach, FLBuilt 1956 · S/N D-4795N4620AGlaser David E · Peyton, COBuilt 1970 · S/N TG-88N4620DJwe Aviation LLC · Sugar Hill, GABuilt 1956 · S/N D-4796N4622DWilson Kevin W · Jacksonville, FLS/N D-4787N4625MSchuster Alexander · Santa Rosa, CABuilt 1978 · S/N E-1247N4626DGoering Ryan I · Prineville, ORBuilt 1956 · S/N D-4779N4627DSheldon Paul T · Saint James, MNBuilt 1956 · S/N D-4785N4628DYester Keith N · Locust Grove, GABuilt 1956 · S/N D-4794N46296L G Merriam Equipment LLC · Chowchilla, CABuilt 1939 · S/N 332N462DMAll In 1 LLC · Watford City, NDBuilt 1961 · S/N D-6848N4633MJ & S Aviation LLC · Clinton, MOS/N CE-816N4634MLearned Doug · Corral De Tierra, CAS/N D-10122N4637ALucky Dog Air LLC · Edmond, OKS/N D-9158N4638ATropical Air Lease LLC · Hialeah, FLBuilt 1971 · S/N TC-1408N4638DCollett William D · Rydal, GABuilt 1956 · S/N D-4805N463BBV-Tail Solutions LLC · Raleigh, NCS/N D-4857N463KNg Aviation LLC · Dover, DEBuilt 1963 · S/N D-7290N463LSilver Development & Associates Inc · Ojai, CABuilt 1978 · S/N P-463N463TCheck 6 LLC · Spearfish, SDBuilt 1963 · S/N D-7083N4640SWeeks Stan Jr · Taneyville, MOBuilt 1964 · S/N D-2308N4644DGarrison Garry L Jr · Lamar, ARBuilt 1956 · S/N D-4839N4645DGoin Jeff W Trustee · Polk City, FLBuilt 1956 · S/N D-4840N4647DWhite Donald W · Mt Vernon, WABuilt 1956 · S/N D-4803N4647SJnjz Enterprises LLC · The Woodlands, TXBuilt 1975 · S/N TC-1910N4648DPeet Edward V · Cornwall, VTS/N D-4848N4648SKoehn Danny · Montezuma, KSBuilt 1975 · S/N E-767N464PGoodgame Richard C · Fort Myers, FLBuilt 1966 · S/N D-8372N464RB75s Leasing LLC · Greenwood Village, COBuilt 1962 · S/N TD-518N464VCraig Michael · Port Orchard, WAS/N TC-1028N4650SMeno Brian P · Collinwood, TNBuilt 1975 · S/N TC-1907N4650VPhillips James A · Lake Arrowhead, CABuilt 1952 · S/N D-457N4651BGlenbear LLC · Kalispell, MTBuilt 1970 · S/N D-9157N4651SScranton Christian · Walnut Creek, CABuilt 1975 · S/N E-766N4652DGentle Giant Innovations LLC · Sheridan, WYBuilt 1956 · S/N D-4837N4653DMccauley Leon J Sr · Woodrow, COBuilt 1956 · S/N D-4852N4656DPueringer David F · Brainerd, MNBuilt 1956 · S/N D-4838N4657DMartin Eugene T · Sioux City, IABuilt 1956 · S/N D-4844N4658DPatterson Michael D · Houston, TXBuilt 1956 · S/N D-4819N465EMFolkerts Jerald L · Pagosa Springs, COS/N D-10001N465NQueen Air Aviation Inc · Belleview, FLBuilt 1967 · S/N LC-255N465PEHoyle Jason R · Grove, OKBuilt 1966 · S/N TE-112N465SAGilmore Air LLC · Boca Raton, FLBuilt 2002 · S/N E-3465N4660DSale Reported · Milwaukee, WISale reportedBuilt 1956 · S/N D-4885N4661DHatcher Charles C · Knoxville, TNBuilt 1956 · S/N D-4855
Back to AD 99-05-13 R1 WD