OpenAirDocs.org
AD 49-45-01

Registered aircraft · 26

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:49-45-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:49-45-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.

N1101WObrien A Scott · Camarillo, CABuilt 1948 · S/N 11-184N1604BCromley Mark C · Lewisburg, PAS/N 11-5N1614BRogers Raylon R DBA · Wellston, OKBuilt 1948 · S/N 11-120N1615BCox Kenneth L · Fremont, NEBuilt 1948 · S/N 11-121N1625BPrice Ronald W · Sonoma, CABuilt 1948 · S/N 11-131N1627BDinnis Wesley J · La Center, WAS/N 11-133N1629BSorenson Fred C · Las Vegas, NVS/N 11-135N1630BFarraginous Air LLC · Wilmington, DES/N 11-136N1631BConservative Three LLC · Taft, CABuilt 1948 · S/N 11137N1632BGirouard Richard J Jr · Anchorage, AKBuilt 1948 · S/N 11-138N1634BPruitt Kerry Pat · Nacogdoches, TXBuilt 1948 · S/N 11-140N1637BSneddon Charles A · Las Vegas, NVBuilt 1954 · S/N 11143N1639BAnderson Mark A · Bates City, MOS/N 11-145N1641BVance Kenneth W · Dolores, COS/N 11-147N1642BWestern Antique Aeroplane & Automobile Museum · Hood River, ORBuilt 1948 · S/N 11-148N1659BPhilbrick Rodney C · Bishop, CABuilt 1948 · S/N 11-165N1661BCromley Mark C · Lewisburg, PABuilt 1948 · S/N 11-167N1666BRamin R Fred · Tomball, TXBuilt 1948 · S/N 11-172N1680BPearce Rick Alan · Parsons, KSBuilt 1948 · S/N 11-186N1684BGreissing John P · Aguila, AZBuilt 1949 · S/N 11-190N1686BNowling Daniel C · Holt, FLS/N 11-192N1687BDendrix Todd M · Bakersfield, CABuilt 1949 · S/N 11-193N1690BMelcher Timothy P · Colleyville, TXBuilt 1949 · S/N 11196N1692BEdgerton Richard Thomas · Arlington, WABuilt 1949 · S/N 11-198N2714KLandreth Homer W · Peoria, AZS/N 11-110N6895CRamin Jeanette J · Houston, TXBuilt 1948 · S/N 11-116
Back to AD 49-45-01