OpenAirDocs.org
AD 59-18-02

Registered aircraft · 116

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-18-02')
    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-18-02')
  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.

N103GClifford Michael P · Paris, TXBuilt 1950 · S/N A533N1140Beechboys Aviation LLC · Wilmington, DEBuilt 1946 · S/N A-129N11863Schwendenman Zachary M · West Covina, CAS/N 51-11863AN118DJInternational Air Services Inc Trustee · Carson City, NVBuilt 1943 · S/N 43-35634N121SCNorth Bay Air Museum · Sonoma, CABuilt 1946 · S/N A-85N125MBLewallen William J · Arizona City, AZBuilt 1942 · S/N AF-286N127MLNiemyjski Justin · Franksville, WIBuilt 1946 · S/N A-212N145AZAmerican Airpower Heritage Flying Museum Inc · Dallas, TXS/N A-235N14PWAudemus Inc · Newport News, VAS/N AF-314N150PRAerojet Servivces Inc · Aurora, COS/N AF-382N1597Registration Pending · Laguna Beach, CARegistration pendingBuilt 1953 · S/N AF-527N165ZAHoffman Carl A · Newnan, GABuilt 1953 · S/N AF543N167ZAAgather V Neils · Fort Worth, TXBuilt 1954 · S/N AF-692N1801DKlaers Lawrence B · Waconia, MNBuilt 1952 · S/N A-816N1828DWalker Matthew James · Henderson, NVBuilt 1952 · S/N A-837N1850North Shore Aviation Services Corp · Waialua, HIS/N AF744N189RHoughton Justin · North Ferrisburg, VTBuilt 1962 · S/N 51-11766N18DTriple Four Mike LLC · Ponte Vedra Beach, FLS/N AF-29N197LAmerican Airpower Heritage Flying Museum · Dallas, TXBuilt 1947 · S/N A-361N213DEVintage Wings Aircraft LLC · Centerpoint, INBuilt 1942 · S/N AF-392N213SPBeech O Sphere LLC · Casper, WYS/N AF-860N21CAJorgensen Bryan H · Wadsworth, OHBuilt 1946 · S/N A-250N223CMPlane Fun Inc Tr Trustee · Snellville, GABuilt 1952 · S/N CA223N241DBarron Aviation LLC · Perry, MOBuilt 1961 · S/N AF-850N2625Aero Specialists Inc · Eloy, AZBuilt 1952 · S/N AF-601N2833GVintage Aero Inc · Brandon, FLBuilt 1951 · S/N AF-159N2913BW Air Collection Inc Trustee · Wilmington, DEBuilt 1953 · S/N A-963N30GAg Air Inc · Matthews, MOBuilt 1946 · S/N A-131N310GBMission Air Aviation LLC · Roanoke, VABuilt 1954 · S/N AF-856N3111Setter Thomas D · Burnsville, MNBuilt 1953 · S/N A-964N325DSteggs Jeff E · Imperial, NEBuilt 1962 · S/N AF-695N33JPScenic Flight Adventures LLC · Coeur D Alene, IDBuilt 1954 · S/N A-998N3500BWalter Charles T Jr · Ocala, FLBuilt 1953 · S/N A-973N3532BPlane Crazy Aviation LLC · Hollywood, SCBuilt 1954 · S/N A-999N3666GDream Weaver Aviation LLC · East Berlin, PABuilt 1951 · S/N 51-11771N40074American Airpower Heritage Flying Museum Inc · Dallas, TXBuilt 1954 · S/N AF 834N404CKN404ck LLC · Anchorage, AKBuilt 1953 · S/N AF-297N411JAukes Brian E · Huxley, IABuilt 1953 · S/N A-967N41289Nizex Inc · Jackson, GAS/N A-475N412KKourtis Vintage Aviation LLC · Owasso, OKBuilt 1946 · S/N A-263N42114Spiller Gary W · Lafayette, ORS/N 39815N42CStage One Associates LLC · Oxford, CTS/N A-468N4356GTop Hand Inc · Laurel, MTBuilt 1951 · S/N CA56N43927Southern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1945 · S/N A-26N44607Shepard Group LLC · Mena, ARBuilt 1945 · S/N A-15N44638Vintage Aircraft Inc · Stockton, CAS/N A-45N4477Parish John Sr · Tullahoma, TNBuilt 1952 · S/N A-935N447DMMorlock Inc · Crossville, TNS/N AF269N45GCAshworth Corp Inc · Geneseo, NYBuilt 1954 · S/N AF-469N45SKPlane Fun Inc Tr Trustee · Snellville, GABuilt 1952 · S/N AF-645
Back to AD 59-18-02