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.

N52852Hultin Ronald · Rosemount, MNBuilt 1974 · S/N 18262897N52853Heintz David A · Culver, ORS/N 18262898N52857Tdex Equipment · Abilene, TXBuilt 1974 · S/N 18262901N52858Channel Islands Aviation Inc · Camarillo, CABuilt 2002 · S/N 172S9186N52859Wehrs Aviation LLC · Johnsburg, ILBuilt 1974 · S/N 18262903N5285DBarker Aviation LLC · Ardmore, OKBuilt 1958 · S/N 50183N5285GGlobe Motorcycles Limited Inc · Pembroke Pines, FLBuilt 1951 · S/N 22716N5285HChild Cris · Mapleton, UTBuilt 1975 · S/N 17265395N5285JJensen Michael J Trustee · Sterling, AKBuilt 1959 · S/N 18-7143N5285KBoland Mark J · Anchorage, AKBuilt 1980 · S/N 17274045N5285PFrank Investments Inc · Austin, TXBuilt 1996 · S/N 29-0081N5285RPuddle Jumper Aviation LLC · Brighton, COS/N 18503027N5285UShroyer Jayme D · Longmont, COBuilt 1964 · S/N U206-0285N5285VMiddletown Regional Flight Training Institute LLC · Middletown, OHBuilt 1980 · S/N 172RG0495N5285YHanson O John · Kaycee, WYBuilt 1964 · S/N 18-8138N52861Holst Thomas C · Pleasant Hope, MOBuilt 1974 · S/N 18262904N52866Egan Bailey J · Forsyth, MTBuilt 1974 · S/N 18262909N5286CUnited Flying Club Inc · Belmont, CABuilt 2002 · S/N 172S9219N5286EButler Bill · Juntura, ORBuilt 1978 · S/N 17271815N5286GPaliughi Ronald D · Fresno, CABuilt 1951 · S/N 22388N5286HNieves Irvyn T · Vega Baja, PRBuilt 1975 · S/N 17265396N5286MSwift Aviation LLC · Silverdale, WABuilt 1978 · S/N MC-570N5286TWilson Aviation LLC · Robinson, ILBuilt 1984 · S/N R18201849N5286WMonea Laurentiu · Brookline, NHBuilt 1962 · S/N 28-335N52873Pepper Daniel J · Henderson, TXBuilt 1974 · S/N 18262916N52876Noteboom Mike · Orange City, IABuilt 1974 · S/N 18262918N52877Weight Malcom E · Spanish Fork, UTBuilt 1981 · S/N 17274626N5287ATax Busters Inc · El Paso, TXBuilt 1979 · S/N 21063349N5287DWitham Kyle S · Lakeview, ORBuilt 1958 · S/N 50185N5287ELin LLC · Dunn, NCBuilt 1978 · S/N 17271816N5287GNoyes Stephen S · Newburyport, MABuilt 1951 · S/N 22723N5287PFogleman Brian L · Stonewall, LABuilt 1958 · S/N 24-326N5287WStump Kenneth H · Ward, ARBuilt 1962 · S/N 28-336N5287YMorrow Aviation LLC · Midland, TXS/N 21064152N52880Matta Sam · Houston, TXBuilt 1974 · S/N 18262921N52884Smith Eric Von Trustee · Vallejo, CAFirst renewal noticeBuilt 1974 · S/N 18262925N52886Gilbert Jack M · Visalia, CABuilt 1974 · S/N 18262927N52888Alphadelta Aviation LLC · East Windsor, CTS/N 18262928N52889Waters Steven D · Kingwood, TXBuilt 1981 · S/N 17274628N5288TG & S Air Adventures LLC · Jersey City, NJBuilt 2002 · S/N 172S9222N5288WMcdowell John Michael · Auburn, CABuilt 1962 · S/N 28-338N52891Registered aircraftBuilt 1981 · S/N 17274629N52895Marshall Brian L · Hays, KSS/N 18262933N52899Kalogerson George G Trustee · Eden Prairie, MNBuilt 1974 · S/N 18262937N5289EFlightco Inc · Swainsboro, GABuilt 1978 · S/N 17271818N5289GRounds Chris · Waller, TXS/N 23417N5289LJames Brandon · Maple Valley, WABuilt 1968 · S/N 28-4590N5289MHardy Caitlin M · Woodinville, WABuilt 1978 · S/N M-2021N5289PVaughan Michael P · Northbridge, MABuilt 1958 · S/N 24-328N5289SHarrison John M · Letart, WVBuilt 1970 · S/N 28-26945
Back to AD 2007-04-19 R1