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.

N36619Gipson Ronnie R · Carlisle, PABuilt 1978 · S/N 28R-7837286N3661CAas LLC · Ovid, MIBuilt 1954 · S/N 31160N3661LAccomazzo Mark E · Charlotte, NCBuilt 1978 · S/N 0816N3661MAlpha Kilo Enterprises LLC · Helena, MTBuilt 1978 · S/N 28R-7837129N3661PBradham David T · Kenai, AKBuilt 1955 · S/N 22-3412N3661QLong Nathan J · Huntsburg, OHS/N MA-251N3661TOmega 1 Corp · Middletown, DEBuilt 1958 · S/N 51001N3661UGlenney Christopher · Milan, NHBuilt 1963 · S/N 18255061N3661WPrete Vincent A · Jim Thorpe, PABuilt 1966 · S/N 32-568N36626Farrier John M · Tillamook, ORBuilt 1973 · S/N 411-74N36628Quale David R · Cottage Grove, WIBuilt 1973 · S/N 113-73N3662CArmi LLC · Nevada, IABuilt 1978 · S/N R18200297N3662RBevard Thomas E · Montross, VABuilt 1969 · S/N 28-5766N3662UBenter Wayne D · Crosby, NDBuilt 1963 · S/N 18255062N3662ZDaniel Dario M · Charlotte, NCBuilt 1960 · S/N 22-7560N3663KEvans And Evans Properties Inc · Santa Cruz, CABuilt 1980 · S/N EA-84N3663QOmalley Edward · Boulder, COBuilt 1980 · S/N E-1691N3663UWilliams James R · Austin, TXBuilt 1963 · S/N 18255063N3663YBrown Robert Scott · Troutman, NCBuilt 1963 · S/N 21058163N3664GMarshmont Aviation LLC · Greenville, SCS/N TJ-280N3664QDiana Scott J · Wallingford, CTBuilt 1967 · S/N MA-249N3664TJdm Aviation LLC · Marceline, MOBuilt 1980 · S/N E-1692N3664UAir Skylane LLC · Boulder, COBuilt 1963 · S/N 18255064N3664WSuffoletto Gregory · Hamburg, NYBuilt 1966 · S/N 32-572N3664XLurie Steven C · Delta, ALBuilt 1968 · S/N 314N3664YWindswept Aviation LLC · North Canton, OHBuilt 1980 · S/N E-1693N3665CN3665c LLC · Otsego, MNBuilt 1978 · S/N R18200299N3665LBeranek John W · Cascade, IABuilt 1978 · S/N 0817N3665NElt Aviation Inc · Peewee Valley, KYBuilt 1967 · S/N 680029N3665PHarness Jesse J · Peoria, AZS/N 18-4621N3665RDomke Kenneth M · Soldotna, AKBuilt 1954 · S/N 18-4112N3665UBlue Skies Aviation Of Wi Inc · Pulaski, WIS/N 18255065N3665WWitham Chris · Cathedral City, CABuilt 1966 · S/N 32-573N3665YJ & B Airlift LLC · Rupert, IDBuilt 1963 · S/N 21058165N36664Strauss Steven Trustee · Tempe, AZBuilt 1980 · S/N EA-89N36665Flynn Michael · Weybridge SurreyBuilt 1980 · S/N E-1696N3666ASandow Dean · Scappoose, ORBuilt 1969 · S/N E-190N3666CStrauss Kenneth W · Vashon, WABuilt 1978 · S/N R18200300N3666KVan Wagner Aerial Media LLC · Hollywood, FLBuilt 1946 · S/N 22356N3666MLarson Samuel T · Anchorage, AKS/N 12-2616N3666QHighum Peter · Hernando Beach, FLBuilt 1967 · S/N MA-253N3666TOlson Ronnie E · Palmer, AKBuilt 1976 · S/N F-073N3666ZWedepohl Richard · Madison, WIBuilt 1960 · S/N 22-7564N36673Gta Air Inc · Addison, TXBuilt 1980 · S/N TH-1143N36674Brown Kile Executor · Dallas, TXBuilt 1965 · S/N 18256440N3667DBpm Rentals Inc · Lincoln, CABuilt 1956 · S/N 35367N3667PSlofly LLC · Red Lodge, MTBuilt 1955 · S/N 18-4624N3667QLife'S A Beech LLC · Wilmington, DEBuilt 1967 · S/N MA-269N3667RShamrock Aviation LLC · Broken Bow, NEBuilt 1970 · S/N 28-5771N3667YAir Wake Aviation LLC · Hazelwood, MOBuilt 1963 · S/N 21058167
Back to AD 2007-04-19 R1