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.

N5262YLead Turn Aviation LLC · Ogden, UTBuilt 2002 · S/N 172S9176N52635Allard Michael · Penrose, COS/N 17274573N5263BFerland Erik · Everett, MABuilt 1957 · S/N 1126N5263GWarhawk Air Museum · Nampa, IDBuilt 1952 · S/N 22346N5263LRjl Aero Inc · Valparaiso, INBuilt 1967 · S/N 28-4561N5263VMccullough James M · Monte Vista, COBuilt 1975 · S/N 21060883N5263WCjco Holdings LLC · Venus, TXBuilt 1962 · S/N 28-309N5264CCullum Transportation LLC · North Charleston, SCBuilt 1979 · S/N 21063725N5264DPironti Bennett D · Long Valley, NJS/N 17272481N5264GMorris Thomas Lee · Sonoma, CABuilt 1950 · S/N 21093N5264JBrowne Bryan C · Allen, TXBuilt 1976 · S/N 414-0854N5264KRmg Aviation LLC · Newark, DEBuilt 1980 · S/N 17274036N5264PBohmer James F · Tulsa, OKS/N 24-300N5264WGray Donald B Trustee · Houston, TXBuilt 1961 · S/N 28-310N5264XTank David M · Cambridge, OHBuilt 1969 · S/N 170N52654Jin Jin Aviation LLC · Anchorage, AKBuilt 1981 · S/N 17274576N5265CWorkman Aircraft Co Inc · Largo, FLBuilt 1978 · S/N 310R1532N5265DFly 172rg LLC · Peoria, AZBuilt 1979 · S/N 17272482N5265ETree Top Flying Service Inc · Clarksville, TNBuilt 1978 · S/N 17271804N5265JSouthern Machine And Steel Inc · Fort Myers, FLBuilt 1976 · S/N 414-0855N5265RMoss Hill Airport Inc · Kinston, NCBuilt 1974 · S/N 17263479N5265WDwight Marketing Corporation · Caldwell, KSBuilt 1962 · S/N 28-311N5265XSwanton Peter K · Willits, CABuilt 1969 · S/N 124N5266ACire Advertising Inc · Norman, OKBuilt 1956 · S/N 35466N5266DColemanation Investments LLC · Naperville, ILBuilt 1979 · S/N 17272483N5266ENatchez Flight Training LLC · Natchez, MSBuilt 1978 · S/N 17271805N5266KCorsicana Aviation Training Services LLC · Corsicana, TXBuilt 1980 · S/N 17274037N5266SFogle Cooper · Mooresville, NCBuilt 1971 · S/N 28R-7135120N5266UN5266u LLC · Brookfield, ILBuilt 1980 · S/N 172RG0312N5266WMichigan Sport Aviators Inc · Midland, MIBuilt 1962 · S/N 28-312N5266XKrabbenhoft J F · Amenia, NDBuilt 1969 · S/N 191N52671Carver Aero LLC · Muscatine, IABuilt 1981 · S/N 17274577N52674Miller Glenn E Trustee · Albany, ORBuilt 1973 · S/N 18262760N52677Spencer Joseph T Jr · Felton, CAS/N 18262763N52678Land And Sea Aviation Alaska LLC · Anchorage, AKBuilt 2026 · S/N 172S13556N5267EBrudelie Alan C · Lewisville, MNBuilt 1978 · S/N 17271806N5267HNichani Nikhil Deepak · Livingston, NJBuilt 1981 · S/N 18267864N5267LBlasi Aviation LLC · Valley Center, KSBuilt 1967 · S/N 28-4565N5267PCarter Jeffrey Lee · Cameron Park, CABuilt 1958 · S/N 24-303N5267RCastlegate Corp · Monee, ILFirst renewal noticeBuilt 2002 · S/N 172S9180N5267SAviation Psych LLC · Neptune Beach, FLBuilt 1980 · S/N R18201530N5267VN5267v LLC · Northbrook, ILBuilt 1975 · S/N 21060886N5267XShelden Seth · Palmer, AKBuilt 1969 · S/N 192N5267YCkb Management LLC · Fayetteville, ARBuilt 2002 · S/N 172S9181N5268Evans Eric A · Saint Peter, MNBuilt 1955 · S/N G-825N52681Clough Robert · Woodinville, WABuilt 1973 · S/N 18262766N52683Cobb John Mark · Fayetteville, TNBuilt 1981 · S/N 17274579N52685Glidewell Aviation Inc · Parkland, FLBuilt 1981 · S/N 17274580N52687Abby Enterprises LLC · Plantsville, CTBuilt 1973 · S/N 18262770N52689Dyberg Mike DBA · Mount Vernon, WABuilt 1973 · S/N 18262771
Back to AD 2007-04-19 R1