OpenAirDocs.org
AD 59-04-01

Registered aircraft · 46

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:59-04-01')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:59-04-01')
  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.

N10RTBarbers Point Flight School LLC · Kapolei, HIS/N 285N1169Downes Pamela · Chino Hills, CABuilt 1956 · S/N 390N1187DCordero Miguel · Hollywood, FLS/N 680-626-252N124JPCommemorative Air Force · Dallas, TXBuilt 1956 · S/N 312N138KSouth Bay Aviation Inc · Torrance, CAS/N 720-621-2N159KIsland Hopper Air LLC · Ponte Vedra Beach, FLBuilt 1959 · S/N 751N2657BHughes Coby D · Collinsville, OKS/N 157N2665BSteria Kermit J · Monahans, TXBuilt 1956 · S/N 374N2700BBackcountry Commander LLC · Wray, COBuilt 1955 · S/N 200N2732BWolff Martin · Houston, TXBuilt 1955 · S/N 232N2750BRodrigues Steven W · Manteca, CABuilt 1956 · S/N 410N2755LMerxbauer Terry E · La Pine, ORBuilt 1955 · S/N 680-255N2782BAbbing Frits G H · Crescent City, FLBuilt 1957 · S/N 559N2788BK&L Agri Farms Inc · Adams, NEBuilt 1957 · S/N 560N289GRAerocomm LLC · Kalispell, MTBuilt 1959 · S/N 795N30UAmerican Airpower Heritage Flying Museum Inc · Dallas, TXBuilt 1955 · S/N 247N312ECAmy Johan J · Coral Springs, FLBuilt 1958 · S/N 676-27N3341Sale Reported · La Plata, NMSale reported, pending cancellationBuilt 1956 · S/N 680-456-126N3836CAdvanced Airways Inc · Loxahatchee, FLS/N 791N3846CCrowder Eston W · Dade City, FLS/N 709N424RKTerry Ryan · White Lake, MIBuilt 1955 · S/N 238N4278SChagnot Catherine J · Athens, OHBuilt 1959 · S/N 680E-813-60N4618ESale Reported · El Paso, TXSale reportedBuilt 1959 · S/N 737N503RTPew Don E · Queen Creek, AZBuilt 1959 · S/N 769N561KEMaglaughlin Ronald D · Udall, KSS/N 680-322-16N56FRWoods Mark T · Fernandina Beach, FLBuilt 1955 · S/N 260N58GSzarek Evelyn Personal Representative · Fairbanks, AKBuilt 1957 · S/N 680-519-189N6217DSmithey Larry M · Wake Forest, NCS/N 680-485-155N6222DRobertson C A · Phoenix, AZS/N 680-490-160N623FSMorse Edward K Jr · Wasilla, AKS/N 578N6267BRosario Angela · San Juan, PRBuilt 1958 · S/N 662N6277BCerra Eduardo · Miami, FLS/N 500-686-33N6278DSale Reported · Oklahoma City, OKSale reportedBuilt 1957 · S/N 548216N6290BCaribbean Shuttle LLC · Aventura, FLBuilt 1958 · S/N 67929N677JRRoach James M · West Bountiful, UTBuilt 1958 · S/N 680-647-254N68113Gogoplex LLC · Wilmington, DEBuilt 1956 · S/N 680-316-11N6819QWalker Gilbert R · Brentwood, TNBuilt 1957 · S/N 680-488-158N6883SWebb Ronald G · Dickson, TNBuilt 1956 · S/N 680-407-83N70DMartin Ernest · Sandpoint, IDS/N 268N711NECommander Flight Group LLC · Charlotte, NCBuilt 1958 · S/N 667N8445CMaddox Jody S · Paterson, WABuilt 1959 · S/N 680E-777-49N8460CState Of Alaska Dept Of Fish & Game · Kodiak, AKBuilt 1959 · S/N 500-799N8468CIntravaia Anthony J · Mountain View, CABuilt 1959 · S/N 680E-802-57N8498CAir Margarita · San Juan, PRBuilt 1960 · S/N 848N9680EMulkey Howard Daniel · Spanaway, WAS/N 699-18N99LQTab Associates Inc DBA · Port Saint Lucie, FLBuilt 1959 · S/N 834
Back to AD 59-04-01