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.

N4772TCaballeros Aircraft LLC · Snohomish, WABuilt 1981 · S/N R18201760N4772YKnutson Wayne R · Tioga, NDBuilt 1968 · S/N 25-4535N47737N47737 Holdings LLC · Gonzales, LABuilt 1977 · S/N 28-7890129N47738Coady Thomas J · Wausau, WIBuilt 1977 · S/N 28R-7837003N4773APaul W Michael · Sprague, WABuilt 1956 · S/N 22-3922N4773BRegistered aircraftBuilt 1955 · S/N 31671N4773CDickert Daniel · Cross City, FLBuilt 1979 · S/N 21063621N4773KReason Farms · Yuba City, CABuilt 1979 · S/N P21000304N4773PCoeur De Air LLC · Mcminnville, ORBuilt 1978 · S/N P21000102N4773SSonrex LLC · Auburn, INBuilt 1979 · S/N R18201423N4773THagerman John · Coxs Creek, KYBuilt 1981 · S/N R18201761N4773UFins Fur & Feathers Flying LLC · King Salmon, AKBuilt 1979 · S/N U20605094N47743Majic T Air LLC · Bradfordwoods, PABuilt 1977 · S/N 32R-7880020N4774AJewett Robert A · Wasilla, AKBuilt 1956 · S/N 22-3923N4774BCunningham Martin Alden · Kansas City, MOBuilt 1955 · S/N 31672N4774EZhao Dan · New York, NYBuilt 1978 · S/N 17271639N4774FIlmberger Stephen J · Bend, ORBuilt 1979 · S/N 17273079N4774JAlbin John B · Milan, MIBuilt 1967 · S/N MA-192N4774KWingfield John J · Parker, TXBuilt 1979 · S/N P21000305N4775BChavez Edward C · Boise, IDBuilt 1955 · S/N 31673N4775DHetrick-Price Willow · Anchorage, AKBuilt 1979 · S/N 17272357N4775KBas Part Sales LLC · Greeley, COBuilt 1979 · S/N P21000306N4775LWadkins Chris H · Plummer, IDBuilt 1967 · S/N 28-4109N4775MJ And J Consulting LLC · South Jamesport, NYBuilt 1978 · S/N D-10131N4775NTennessee Metals Recycling LLC · Murray, KYBuilt 1979 · S/N 18267358N4775PRegistered aircraftBuilt 1975 · S/N 20675N4775QShelk John Brian · Bend, ORBuilt 1967 · S/N 185-1242N4775UBishop Mike · Rifle, COBuilt 1964 · S/N 18051475N47764Wl Aviation LLC · Olney, MDBuilt 1977 · S/N 32R-7880021N47767Capps Clinton Wyatt · Navasota, TXBuilt 1977 · S/N 28-7816132N47768Registered aircraftBuilt 1977 · S/N 28-7816133N4776BLarsen Christopher F · Fairbanks, AKBuilt 1955 · S/N 31674N4776EAlpha One Aviation LLC · Dunedin, FLBuilt 1978 · S/N 17271641N4776JKimbrough Paul E · Millcreek, UTBuilt 1967 · S/N MB-221N4776LHitt John C · Plano, TXBuilt 1967 · S/N 28-4110N4776NRegistration Pending · Ceiba, PRRegistration pendingBuilt 1979 · S/N 18267359N4776THigh Planes Air Service · Bismarck, NDBuilt 1981 · S/N R18201762N4776UHabberstad John L · Rathdrum, IDBuilt 1979 · S/N U20605096N47773Walo Barry F · Cresson, TXBuilt 1977 · S/N 28-7890137N4777JHowell Michael A · Parsons, KSBuilt 1967 · S/N MB-224N4777LRoss Charles B · Anchorage, AKBuilt 1967 · S/N 28-4111N4777NRosario Edwin A · Pine Island, NYBuilt 1979 · S/N 18267360N4777SN4777s LLC · Ault, COBuilt 1980 · S/N R18201424N4777UAdair Aviation LLC · Broken Arrow, OKBuilt 1983 · S/N 21064814N4778CDwstults Enterprises LLC · Winter Haven, FLBuilt 1965 · S/N TC-936N4778EClemmons Flyers LLC · Green Cove Springs, FLS/N 17271643N4778FPond Engineering Laboratories Inc · Berthoud, COBuilt 1967 · S/N P206-0378N4778LGarrett Russell K · Hazen, NDS/N 28-4112N4779TAmerican Aerial Patrol LLC · Saint Amant, LABuilt 1981 · S/N R18201764N4779UBergh Eugene H · Roberts, WIBuilt 1964 · S/N 18051479
Back to AD 2007-04-19 R1