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.

N272SCRobert Gardner Enterprises LLC · Mercer, MEBuilt 1977 · S/N 18052939N272SDVigneault Leonard J · Southbridge, MABuilt 2018 · S/N 71662N272SEFoley Aviation LLC · Evans City, PABuilt 2016 · S/N 13947N272SGLehner Raymond A Jr · North Fort Myers, FLBuilt 2004 · S/N 969-2004N272TWillis Patrick A · Eugene, ORBuilt 1995 · S/N 21N272TCMiller Ralph · Fleming Island, FLS/N 001N272TLSanders Flight Training Center · Jasper, ALS/N 17270719N272TNReed Perry L · Mooresville, NCBuilt 1977 · S/N 17268803N272VWigley Ben Jr · Huntington, ORBuilt 1956 · S/N 33362N272VXSpence Lorne J · Saint Cloud, FLBuilt 2019 · S/N 140272N272WCCandace A Larned Enterprises Inc · Long Beach, CABuilt 1979 · S/N 17272677N272WYSale Reported · Eden Prairie, MNSale reported, canceledBuilt 2016 · S/N 3272N272ZMarson Richard W · Eagle River, AKBuilt 1998 · S/N 1050N27300Rankin Kevin J · Maryville, MOBuilt 1998 · S/N 17280551N2730ASteigenga Nathan L · Suffolk, VAS/N E-1229N2730EOew Aviation LLC · Sumter, SCBuilt 1978 · S/N 17271309N2730MSua LLC · Artesia, NMBuilt 1980 · S/N 414A0437N2730QSkylane Corp · Pittston, PABuilt 1967 · S/N 18257930N2730RRp Aviation Inc · Alliance, OHBuilt 1978 · S/N CE-792N2730WKegg Larry R · Chesapeake, VABuilt 1966 · S/N 3429N2730XSmith Daniel E · Anchorage, AKBuilt 1965 · S/N 18051530N2731KYoung Aviation LLC · Oshkosh, WIBuilt 1979 · S/N 18053045N2731MBosn Richard O · Scottsbluff, NEBuilt 1977 · S/N 28-7890265N2731Q31q LLC · Boise, IDBuilt 1967 · S/N 18257931N2731TFocus LLC · Missoula, MTBuilt 1967 · S/N D-8454N2731WUsrey Curtis R · Sullivan, INBuilt 1966 · S/N 1033N2731YGeorgia Forestry Commission · Macon, GABuilt 2003 · S/N 18281202N2732GPrince Benjamin D · Lincoln, MTS/N 52032N2732KDixie Sand And Gravel LLC · Edisto Island, SCBuilt 1979 · S/N 18053046N2732TJellor Realty Inc · Los Angeles, CABuilt 1979 · S/N 414A0449N2732WReik Martina · Novi, MIBuilt 1966 · S/N 1034N27339Rice John G · Craig, AKBuilt 1970 · S/N 18052140N2733FMetzger William M · Boonville, INBuilt 1965 · S/N 18256833N2733GSkydive Ky LLC · Cecilia, KYS/N 52033N2733KRegistered aircraftBuilt 2006 · S/N 40517N2733RPatrick Barb · Farmer City, ILBuilt 1969 · S/N 28R-35275N2733WMclenaghan Alvin N · Phoenix, AZBuilt 1966 · S/N 3341N27347Cochran Douglas C · Saranac Lake, NYBuilt 1954 · S/N 18-4032N2734BStella Air Inc · Wyoming, PABuilt 1979 · S/N 414A0454N2734FWard Christopher C · Lufkin, TXBuilt 1965 · S/N 18256834N2734GSplit Rock Aerospace LLC · Southport, CTBuilt 1979 · S/N 414A0456N2734HGriebel Kyle L · Lafayette, COBuilt 1959 · S/N 52034N2734Q1175 Bangtail Way LLC · Greycliff, MTBuilt 1967 · S/N 18257934N2735JAlpha 414a LLC · New Smyrna Beach, FLBuilt 1980 · S/N 414A0466N2735KCook Kyle R · Green Valley, AZBuilt 1979 · S/N 18053049N2735PTaylor William W Jr · Hudson Oaks, TXBuilt 1955 · S/N 22-3042N2735QRegistration Pending · Hearne, TXRegistration pendingBuilt 1967 · S/N 18257935N2735TWhite Michael W · Key Largo, FLBuilt 1967 · S/N D-8455N2736GFor Skies Flying Club Ltd · Martinsville, ILBuilt 1959 · S/N 52036N2736KP M Logistics LLC · Haskell, OKBuilt 1979 · S/N 18053050
Back to AD 2007-04-19 R1