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.

N2914LPanalucent LLC · Saint Petersburg, FLBuilt 1967 · S/N 670486N2914MPannone Steven R · Palmer, AKBuilt 1947 · S/N 12-1334N2914PPerreault Guy · Newbury Park, CABuilt 1955 · S/N 22-3182N2914QEast High Flying · Othello, WABuilt 1987 · S/N 1028N2914RLandrith Robert L · Mustang, OKBuilt 1969 · S/N 28R-35327N2914TTp Aviation Inc · Augusta, KSBuilt 1966 · S/N 320N2914YBol Aero LLC · Beverly Hills, CABuilt 2004 · S/N 0859N2914ZEarle Russell John · Reno, NVBuilt 1959 · S/N 22-6884N29151Inland Aerial Surveys Inc · Riverside, CABuilt 1968 · S/N U206-1121N29157Midwest Aero Inc · Bay City, MIBuilt 1979 · S/N 32-7940130N29159Southridge Developments Inc · San Miguel, CAFirst renewal noticeBuilt 1974 · S/N 17264103N2915BRobble Group LLC · Center Valley, PABuilt 1986 · S/N E-2314N2915CField Jeff H · Simi Valley, CAFirst renewal noticeBuilt 1954 · S/N 30815N2915FStoffregen Thomas S · Milton, WVBuilt 1966 · S/N 18257015N2915GWalls Properties LLC · Paragould, ARBuilt 1979 · S/N 28-7911243N2915LZorro Stephen · Rocklin, CABuilt 1967 · S/N 670309N29160Felber Dave A · Florissant, MOBuilt 1974 · S/N 17264104N29164Iturriria John · Kuna, IDBuilt 1968 · S/N U206-1133N29168Galer Michael J Jr · Lockwood, MOBuilt 1974 · S/N 17264105N2916AMetro Service Air Inc · Fairbanks, AKBuilt 1953 · S/N 30116N2916FAndros Marketing LLC · Fort Lauderdale, FLBuilt 1966 · S/N 18257016N2916LPospisil Thomas · Rockwood, PABuilt 1967 · S/N 670310N2916TLewis Paul A · Spring, TXBuilt 1966 · S/N 322N2916WPilots Flying School LLC · Manalapan, NJBuilt 1979 · S/N 44-7995300N29170Kuhlmann Connor · Ada, MIBuilt 1979 · S/N 32-7940131N29172Reutter David C · Mount Kisco, NYBuilt 1979 · S/N 32-7940132N29173Aerial Transport LLC · Wilmington, DEBuilt 1968 · S/N U206-1140N29176Tgr Helicopters · Fresno, CABuilt 1973 · S/N 21059828N2917CParks Joseph S · Wilmington, NCBuilt 1954 · S/N 30817N2917FBennett David D · Clinton, WABuilt 1966 · S/N 18257017N2917LDobbs J S · Medford, ORBuilt 1967 · S/N 670311N2917PRegistered aircraftBuilt 1955 · S/N 22-3185N2917RCzarnecki Neil A · Racine, WIBuilt 1969 · S/N 28R-35328N2917ZRegistration Pending · Granby, MORegistration pendingBuilt 1959 · S/N 22-6887N29181Wings Of Faith · Stevensville, MTBuilt 1968 · S/N U206-1147N29186Thoroughbred LLC · Kalispell, MTBuilt 1968 · S/N U206-1151N29188Rugger Investment Group LLC · Tustin, CABuilt 1968 · S/N U206-1153N2918DMelton Derrick · Midland, TXBuilt 1979 · S/N 28-7911245N2918EDelpenn Flyers Inc · Dover, DEBuilt 1978 · S/N 17271372N2918KHolmes Ronald W · Kent, ORS/N 18053128N2918LHieb Jared J · Amarillo, TXBuilt 1987 · S/N 1030N2918PLafferty Eric M · Anchorage, AKBuilt 1955 · S/N 22-3186N2918RTown Thomas L · Chino Valley, AZBuilt 1968 · S/N 310G0118N2918VLinse Shane G · Billings, MTS/N 134N2918XFlight Leasing Corp · Wilmington, DEBuilt 1979 · S/N 28-7916543N2918ZLarson David R · Boerne, TXS/N 22-6888N2919CRudolph Darren M · Wasilla, AKBuilt 1954 · S/N 30819N2919FPerez Adolfo · Conroe, TXBuilt 1966 · S/N 18257019N2919KWoodaire Ltd · Coeur D Alene, IDBuilt 1979 · S/N 18053129N2919TParsons William Tony Jr · Medina, TNBuilt 1966 · S/N 325
Back to AD 2007-04-19 R1