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.

N55260Weich Ronald L · El Paso, TXBuilt 1973 · S/N 28-7305343N55261Barton John S III · Gallatin, MOBuilt 1973 · S/N 28-7305344N55263Fennell Donald H Jr · Hampstead, NCBuilt 1973 · S/N 28-7305345N55264Ace Aircraft Leasing Inc · Nazareth, PABuilt 1981 · S/N 17275147N5526BDoelger Parker · Norwood, NYBuilt 1956 · S/N 33526N5526FLandry Raymond L · Stark, NHBuilt 1968 · S/N 28-24867N5526JBravo Leasing LLC · Daytona Beach, FLBuilt 2014 · S/N 172S11484N5526KOn-Site Aviation Inc · Hillsboro, NDBuilt 1978 · S/N 273-78N5526MEz Breezy Fc LLC · San Diego, CAS/N 28-22539N5526PWard County Irrigation District #1 · Barstow, TXS/N 24-589N5526UPearl Wings LLC · Doylestown, OHBuilt 1969 · S/N 28-26242N55270Mcconnell Jason A · Rose Hill, VABuilt 1973 · S/N 28-7325356N55272Nienhuis Alvin Dale II · Brooksville, FLBuilt 1973 · S/N 28-7305348N55273Jcb Aircraft Sales & Leasing Inc · Belle Mead, NJBuilt 1973 · S/N 28-7305349N55275Bas Part Sales LLC · Greeley, COBuilt 1973 · S/N 28R-7335209N55278Hackman Daniel W · Wimauma, FLBuilt 1973 · S/N 32-7300035N55279West Georgia Air Services · Lagrange, GABuilt 1973 · S/N 34-7350195N5527AMokiy LLC · Aurora, ORBuilt 1985 · S/N P21000861N5527BAdrenaline Inc · Chambersburg, PAS/N 33527N5527DCarns Ronald · Killeen, TXBuilt 1957 · S/N D-5063N5527FFarnie Christopher J · Jacksonville, FLBuilt 1968 · S/N 28-24868N5527JBeachside Transports LLC · Hampstead, NCBuilt 1967 · S/N 32-987N5527SSilver State Aero Group LLC · Discovery Bay, CABuilt 1980 · S/N R18201595N55284Winters Daniel K · Pennsburg, PABuilt 1973 · S/N 28-7325359N55285Aerosim Academy Inc · Sanford, FLBuilt 2014 · S/N 172S11511N55287Prairie Winds Aviation LLC · Overland Park, KSBuilt 1973 · S/N 28R-7335210N55289May Richard J · Fallbrook, CABuilt 1973 · S/N 32-7300036N5528KGates Steven S · Midlothian, TXBuilt 1978 · S/N 388-78N5528QCralle Family Aviation LLC · Midland, TXBuilt 1965 · S/N 617N5528RVroom Brian D · Tucson, AZS/N 172RG0071N5528SCenturion N761lu LLC · Mukilteo, WABuilt 1980 · S/N R18201596N5528VTrusler William L · Magnolia, TXBuilt 1990 · S/N CE-1426N55291Riverside Flight Academy LLC · Riverside, CABuilt 1981 · S/N 17275152N55292Aerosim Academy Inc · Sanford, FLBuilt 2014 · S/N 172S11515N55294Heavy Metal Air LLC · Farmingdale, NYBuilt 2014 · S/N 172S11516N55296Heavy Metal Air LLC · Farmingdale, NYBuilt 2014 · S/N 172S11517N55297Goodhue LLC · Myrtle Beach, SCBuilt 2014 · S/N 172S11518N55299Trego/Dugan Aviation Of Grand Island Inc · Grand Island, NEBuilt 1981 · S/N 17275154N5529DKanieski Maximilian M · New Canaan, CTBuilt 1989 · S/N CE-1403N5529FKeiner Larry E · Drums, PABuilt 1968 · S/N 28-24871N5529JFarsighted Aviation LLC · Connersville, INBuilt 1968 · S/N 32-990N5529NTime 2 Fly LLC · Conroe, TXBuilt 1980 · S/N 18267771N5529QWhipple Ron · Etna, CABuilt 1965 · S/N 2953N5529SBreaking Wind Aviation LLC · Brainerd, MNBuilt 1980 · S/N R18201597N5529UStoll Travis · El Dorado Springs, MOBuilt 1969 · S/N 28-26245N5529VCandlestick Aviation Services LLC · Lewes, DEBuilt 1984 · S/N T30300303N5529WHarvey Gregory D Sr · Greenbush, MEBuilt 1962 · S/N 28-623N5529ZAerosim Academy Inc · Sanford, FLS/N 172S11514N552BWinkelbauer Kim G · Sun City, AZBuilt 1967 · S/N D-8524N552BBFrench Don Robles · Glendale, AZBuilt 1970 · S/N TE-800
Back to AD 2007-04-19 R1