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.

N5278WJohns Tyler B · Folsom, CABuilt 1962 · S/N 28-326N5278XFisher Bryan S · Galveston, TXBuilt 1969 · S/N 221N52792Ball Richard W · Ridgefield, CTBuilt 1974 · S/N 18262848N52794Hawk Flyer 794 LLC · San Bruno, CABuilt 2002 · S/N 172S9211N52795Key Lime Consultants LLC · Belleview, FLS/N 18262851N52797Supinie Andy · Wichita, KSBuilt 1974 · S/N 18262852N5279DDay Aviation Inc · Wilmington, DEBuilt 1979 · S/N 17272489N5279GArnold Jason Mcree · Watkinsville, GABuilt 1979 · S/N 17273558N5279LCarverair LLC · Lakeland, FLBuilt 1967 · S/N 28-4578N5279MTownsend Tod N · White Sulphur Spgs, MTBuilt 1949 · S/N 18-119N5279TDicecco Jennifer · West Chester, PABuilt 1972 · S/N 28-7225386N5279WAmerican Aviator LLC · Arlington, TXBuilt 1962 · S/N 28-328N527ABPriest Justin E · Arlington, WABuilt 1995 · S/N 774N527AWSkyhawk Td LLC · Siloam Springs, ARBuilt 1988 · S/N 1455N527BCYager Greg J · Columbia Falls, MTBuilt 2005 · S/N 22465N527BHRed River Cellular Telephone Corp · Paris, TXBuilt 1980 · S/N TH-1190N527BKShires Patrick O · San Andreas, CABuilt 1978 · S/N 28-7890310N527CCUS Department Of The Interior · Boise, IDBuilt 2012 · S/N CC18-0063N527CDAircraft Medical Solution LLC · Kissimmee, FLBuilt 2005 · S/N 1628N527CGGibbs Tyler · Gilbert, AZS/N 686N527DAltman Aviation Services LLC · Lockhart, TXBuilt 1962 · S/N 310G0112N527DSSkyhawk Leasing LLC · Greenfield, INBuilt 2004 · S/N 172S9588N527ECRdec LLC · Wilmington, DEBuilt 2020 · S/N 41855N527FPhillips Flying Inc · Saluda, NCS/N 71072N527FLPatterson Roy A · Cameron, TXS/N 28-7125354N527GTSchellhase Walter S · Kerrville, TXBuilt 1980 · S/N 14528N527JBSoutheast Anesthesia Plc · Mcdonald, TNS/N 1243N527JHTugende LLC · Montrose, COBuilt 1979 · S/N 340A0782N527JPPerritt John Olin III · Clayton, NCBuilt 2003 · S/N JP-5N527LMacan Ed · Overland Park, KSBuilt 1975 · S/N 28-7505228N527MLMoss Herman D · Centreville, VABuilt 1966 · S/N TE-217N527NDPhoenix East Aviation LLC · Daytona Beach, FLBuilt 2008 · S/N 172S10818N527RJGonzales Denise E · Fort Worth, TXBuilt 1996 · S/N 24-3382N527RSRamsey Wayne V III · Abilene, TXBuilt 1999 · S/N E3222N527SPRose Arthur K · Florence, ALBuilt 1991 · S/N 849N527TFlying H Enterprises LLC · Smithville, MOBuilt 1964 · S/N TC-576N527TAPlane Leasing LLC · Wilmington, DEBuilt 1973 · S/N TH-290N527TCLeonardo Paul A III · Merced, CABuilt 1991 · S/N EA-527N527TMCampbell Air Services Inc · Roseville, CABuilt 2006 · S/N 29-0451N527TRDawson Kevin · Colorado Springs, COBuilt 2002 · S/N 0265N527VBPipping Construction LLC · Rosendale, WIBuilt 2015 · S/N 13803N527VMBradley Christopher · Orange, TXBuilt 2002 · S/N 11337N527WMitchell Grayson · Milledgeville, GABuilt 2000 · S/N 29-0224N527WPProctor Justin Paul · New Bern, NCBuilt 1968 · S/N 28R-30977N527YMues John C · Wasilla, AKBuilt 1946 · S/N 12-312N52806Skywarrior Flight Training Inc · Pensacola, FLBuilt 1981 · S/N 17274610N52808Thane Inc · Elkridge, MDBuilt 1974 · S/N 18262862N5280DHdw Florida Helicopters Inc · Pompano Beach, FLBuilt 2002 · S/N 172S9212N5280EStreeter Byrand DBA · Newcastle, WYBuilt 1978 · S/N 17271810N5280MN5280m LLC · Elizabeth, COBuilt 1979 · S/N 17273671
Back to AD 2007-04-19 R1