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.

N3682ZIliamna Air Taxi Inc · Iliamna, AKBuilt 1980 · S/N TH-1159N36838Sapphire Air LLC · Keystone, COBuilt 1978 · S/N 28R-7837296N3683RRegistered aircraftBuilt 1969 · S/N 28-5785N3683WHaure Pierre II · Rayne, LABuilt 1966 · S/N 32-593N36846Armbruster LLC · Amherst, OHBuilt 1979 · S/N 310R1600N36847Thrash Howard G II · Lubbock, TXBuilt 1980 · S/N EA-115N3684ARegistered aircraftBuilt 1980 · S/N CE-916N3684CFly Away Aviation LLC · Folsom, LABuilt 1978 · S/N R18200307N3684HAvex X Corp · Coral Gables, FLBuilt 1981 · S/N TE-1180N3684LLucke Eva DBA · Minot, NDBuilt 1978 · S/N 0819N3684RCulbert Megan C · Woodbury, NJBuilt 1969 · S/N 28-5786N3684UToews Berton J · Casper, WYBuilt 1963 · S/N 18255084N3684YBluebird Holdings LLC · Morris, MNFirst renewal noticeBuilt 1980 · S/N TJ-298N3684ZStevenson William E · Sutton, AKBuilt 1960 · S/N 18-7416N36855Aerial Digital Images LLC · Huntington Beach, CABuilt 1980 · S/N EA-117N3685ABartlett Jeffrey D · Black Diamond, WABuilt 1953 · S/N 18-3033N3685QEaston Bryan L · Council Bluffs, IAS/N MA-259N3685RRailey Dustin Ward · Broxton, GABuilt 1970 · S/N 28-5787N3685WJewell Warren · Seattle, WABuilt 1980 · S/N EA-113N3685YWhite Lawrence L III · La Habra, CABuilt 1963 · S/N 21058185N3685ZMaus Christopher J · Anchorage, AKBuilt 1960 · S/N 18-7417N36861Registered aircraftBuilt 1986 · S/N 0584N36862Linville Keith · Bend, ORBuilt 1979 · S/N 310R1605N3686BBrosius John W III · Dell Rapids, SDBuilt 1962 · S/N NAV42419N3686CSedwick William R · Anchorage, AKBuilt 1954 · S/N 31185N3686RNeal Matthhew Z · Mansfield, OHBuilt 1970 · S/N 28-5788N3686UEnvi Adventures LLC · Troutdale, ORBuilt 1963 · S/N 18255086N3686WLadet William D · Las Vegas, NVS/N 32-596N3686YEllis Air LLC · Acworth, GAS/N 21058186N36877Stilwell Aviation LLC · Stilwell, KSBuilt 1980 · S/N EA-119N3687QHjelle Tim D · Malone, WIBuilt 1967 · S/N MA-270N3687WBluewater Marine Group Inc · Wilmington, DEBuilt 1966 · S/N 32-597N3687ZScott Marilyn F Trustee · Sun City West, AZFirst renewal noticeBuilt 1960 · S/N 18-7420N36884Main Aviation Inc · Visalia, CABuilt 1980 · S/N EA-121N36885Sky West Aviation Inc Trustee · Albuquerque, NMBuilt 1979 · S/N 340A0681N36887Aa Aircraft Adventure LLC · Joplin, MOBuilt 1982 · S/N 414A0835N3688CDiedrich Steve A · Sandpoint, IDBuilt 1954 · S/N 31187N3688KFlying Trout LLC · Port Orchard, WAS/N 28-23688N3688MHammons Clayton W · Salome, AZBuilt 1946 · S/N 12-2634N3688QFour Musketeers LLC · Wichita, KSBuilt 1967 · S/N MA-272N3688RMckay Christopher · Point Arena, CAS/N CE-918N3688UTaylor Aviation Inc · Fort Benton, MTBuilt 1963 · S/N 18255088N3689CR D Management LLC · Central City, NEBuilt 1978 · S/N R18200309N3689PMcaneney Joseph R · Talkeetna, AKS/N 18-4590N3689QBusick Aviation LLC · England, ARBuilt 1967 · S/N MA-271N3689RBdj Farms · Hallock, MNS/N 28-5733N3689ULeonard Robert E · Mattoon, ILBuilt 1980 · S/N E-1733N368BVinnola Bruce L · Glenrock, WYBuilt 1957 · S/N D-5107N368BCAugustina Holdings LLC · Argyle, TXS/N 182-68517N368CDSavfar Aviation Inc · Wilmington, DEBuilt 2004 · S/N 1071
Back to AD 2007-04-19 R1