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.

N38049Moore Aviation Services LLC · San Antonio, TXBuilt 1980 · S/N EA-178N3804ABig Love LLC · Tifton, GABuilt 1983 · S/N TH-1381N3804DGabbert Lucious L · Prescott, AZBuilt 1957 · S/N 34504N3804KWebster Max S · Dalton, PABuilt 1967 · S/N 28-23736N3804MGlenmont Air LLC · Strasburg, VABuilt 1981 · S/N TJ-328N3804PMadsen Theodore W · Gillette, WYBuilt 1955 · S/N 22-3493N3804QWings Over Texas Holdings LLC · Denton, TXBuilt 1971 · S/N 17259904N3804TMarello Thomas J · Westminster, MDBuilt 1967 · S/N 28R-30118N3804YChelmo Jed E · Kimball, SDBuilt 1964 · S/N 21058304N3804ZCulbertson William Theodore · Helena, MTBuilt 1960 · S/N 18-7537N3805DThurier Lawrence V · Stevens Point, WIBuilt 1957 · S/N 34505N3805FSmith James E Trustee · Kalispell, MTBuilt 1977 · S/N 0773N3805NHopkins Michael P · Granbury, TXBuilt 1968 · S/N 680124N3805PSpinner Family Lp · White City, ORBuilt 1955 · S/N 22-3494N3805TEyth Isaac S · Fe Warren Afb, WYBuilt 1969 · S/N 28R-30119N3805YMacys Flying Service Inc · Tulelake, CABuilt 1964 · S/N 21058305N38065Boyd David · Havasu, AZBuilt 1980 · S/N D-10361N3806FSkytours Aerial LLC · Jackson, MIBuilt 1977 · S/N 0774N3806LPeterson Ross D · Hutchinson, MNBuilt 1980 · S/N E-1793N3806MAbbott Cedric M · Buckfield, MEBuilt 1947 · S/N 12-2563N3806TFacklair LLC · Granville, OHBuilt 1967 · S/N 28R-30120N3806YOnion Crest Air LLC · Arcadia, NEBuilt 1964 · S/N 21058306N3806ZNamtvedt Erik · Wasilla, AKS/N 18-7539N38071Carter Donald P Trustee · Merced, CABuilt 1980 · S/N CE-935N3807EDonaghe Larry Chance · Rockwall, TXBuilt 1981 · S/N E-1809N3807FDeno Gerald G · Battle Creek, MIBuilt 1977 · S/N 0775N3807JJohnson Gunnar W · Wasilla, AKBuilt 2012 · S/N 00100N3807PLuebber Jan D · Malaga, WAS/N 22-3496N3807TAmbrose Construction Ltd · Corpus Christi, TXBuilt 1980 · S/N TJ-332N3807WFeller Gerald A · Long Beach, CAS/N 32-736N3807XAlpha Bravo Lima LLC · Covington, TNBuilt 1980 · S/N EA-179N38081Heitmeier Cody F · New Orleans, LAS/N E-1798N38082Pope Bill F · Prescott Valley, AZBuilt 1980 · S/N EA-183N38088Toledo Jorge A · Coral Gables, FLS/N TC-2366N38089Dabbs Randal L · Lenoir City, TNBuilt 1980 · S/N TH-1218N3808DByrd David P · King Salmon, AKBuilt 1957 · S/N 34508N3808FChandler Air Service Inc · Chandler, AZBuilt 1977 · S/N 0776N3808MWings Of Clearfield Inc · Centre Hall, PABuilt 1978 · S/N 28-7816377N3808QJordan Klein DBA · Summerfield, FLS/N CE-936N3808RCatalano Joan E · Sequim, WABuilt 1970 · S/N 28-5834N3808WDodson International Parts Inc · Rantoul, KSBuilt 1966 · S/N 32-737N3809DRhoads William · Williamsburg, VABuilt 1957 · S/N 34509N3809MWood Robert A V · Anchorage, AKBuilt 1947 · S/N 12-2731N3809TMiller Jo Ann · Atlanta, GABuilt 1967 · S/N 28R-30124N3809WFair Skies Aviation LLC · Cincinnati, OHBuilt 1966 · S/N 32-739N3809XVoracek Michael G · Richardson, TXBuilt 1966 · S/N 310K-0209N380AURunamuck LLC · New Orleans, LABuilt 2025 · S/N 4496618N380BFTidmore Argie D · Pottsville, PABuilt 2005 · S/N 6072N380BPMoe Michael J · Detroit Lakes, MNBuilt 1996 · S/N 1N380BTPiper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 28010084
Back to AD 2007-04-19 R1