AD 2007-04-19 R1

Registered aircraft · 108,434

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

N55VLDarian Alexander L · Brightwaters, NYBuilt 1979 · S/N AA5B1065N55VSSkie Flying Club LLC · Campbell, CAS/N CE-1305N55WAHudgens Terry L · Blockton, IABuilt 1972 · S/N 216N55WBMetro Flyers Ltd · Wilmington, DEBuilt 1975 · S/N 18263900N55WCHagan Jeremy D · Madrid, NEBuilt 1975 · S/N AA5B-0216N55WMBankston Jeffery · Rice, TXBuilt 1978 · S/N R18200757N55WRNeumann Capital Holdings LLC · Bossier City, LABuilt 1965 · S/N D-7799N55WYCentury White Worldwide Inc · Casper, WYBuilt 1966 · S/N TE-241N55XFCeb Enterprises LLC · Petal, MSBuilt 1972 · S/N 28-7325132N55XLBusiness Development Systems LLC · Seaford, VABuilt 2002 · S/N 3RX027N55YBLockhart John E · Phoenix, AZBuilt 1967 · S/N TE304N55ZZMaxson Lee V · Mesa, AZBuilt 1966 · S/N TE-133N56000Wings Over Texas Holdings LLC · Denton, TXBuilt 1973 · S/N 34-7350270N56001Citabria LLC · Missoula, MTBuilt 1982 · S/N VAC-184-82N56002Clark William · Gig Harbor, WABuilt 1982 · S/N VAC 185-82N56007N56007 LLC · Burke, VABuilt 1973 · S/N 28-7325553N56008F R G III Inc DBA · Lincoln Park, NJBuilt 1973 · S/N 28-7305517N5600BParks Darryl D Trustee · Eagle River, AKBuilt 1956 · S/N 33600N5600CRegistered aircraftBuilt 1981 · S/N VAC 176-81N5600JHigh Country Aircraft LLC · Westcliffe, COBuilt 1981 · S/N VAC 177-81N5600KHurta Jennifer Nelsen · Cypress, TXBuilt 1964 · S/N D-7369N5600MClarke Michael J · Baker, FLBuilt 1982 · S/N VAC-183-82N5600QA & D Aviation LLC · Aberdeen, OHS/N 656N5600UCorey Marlin F · Choctaw, OKBuilt 1966 · S/N 28-22203N5600WFitzgerald Anthony M · Crete, NEBuilt 1962 · S/N 28-737N5600YNelson Kenneth A · Fort Mill, SCBuilt 1982 · S/N VAC188-82N56015Ac Sales & Investments LLC · Hickory, NCBuilt 1973 · S/N 28-7305518N5601EMarshall Joseph · Uniontown, OHBuilt 1983 · S/N 18268333N5601GRetzlaff Cathy S · Oshkosh, WIBuilt 1985 · S/N VAC189-85N5601JGoos Lynn A · Silver City, IABuilt 1974 · S/N 18263458N5601PDevil Dusters Inc · Artesia, NMS/N 24-669N5601QRegistered aircraftBuilt 1965 · S/N 2999N5601SArno Aero LLC · Merton, WIBuilt 1966 · S/N D-8152N5601WTaylor Larry J · San Manuel, AZBuilt 1962 · S/N 28-738N56023Bennett Paul · Phoenix, AZBuilt 1973 · S/N 28R-7335336N5602JVarga Aircraft Co · Hephzibah, GAS/N VAC18282N5602QWacker Jeremy C · Denver, COBuilt 1965 · S/N 3102N5602SRegistered aircraftBuilt 1966 · S/N D-8153N5602WSaunders Nathaniel E · Muskegon, MIBuilt 1962 · S/N 28-739N56031Musser John R · Freeport, ILBuilt 1973 · S/N 28R-7335338N56032Umo Flight School LLC · Mount Olive, NCBuilt 1973 · S/N 28R-7335339N56033Larson Douglas R · Goodyear, AZBuilt 1973 · S/N 287310168N5603JMiller Duane A · Redlands, CABuilt 1974 · S/N 18263460N5603LKushnir Borys G · Tamuning, GUBuilt 1974 · S/N 0702N5603PLitteken David T · Aviston, ILBuilt 1959 · S/N 24-671N5603WElliot Harold F II · Pomeroy, OHBuilt 1962 · S/N 28-740N56041Haddad Joe · Charlotte, NCBuilt 1973 · S/N 28-7325562N5604JJohnson David A · Sunrise Beach, TXBuilt 1974 · S/N 18263461N5604KX-Country Ventures LLC · Usafa, COBuilt 1964 · S/N D-7459N5604QSkywagons.Com LLC · Placerville, CABuilt 1965 · S/N 658
Back to AD 2007-04-19 R1