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.

N279RARusso Robert Michael · Pipersville, PABuilt 2005 · S/N 1392-2005N279RVStewart James L · Garden City, TXBuilt 2016 · S/N 90299N279RWPoe James K · Walterboro, SCBuilt 1959 · S/N 52347N279SVGeorge W Goodknight Inc · Chattanooga, OKBuilt 1979 · S/N 79-30939N279WYMccarty David · Baker City, ORBuilt 2017 · S/N 3279N279YRegistration Pending · Seneca, SCRegistration pendingBuilt 2008 · S/N 027N27AHM W T Aviation LLC · Jamestown, NYBuilt 1975 · S/N 17265306N27AKLingle Bryan K Sr · Bradenton, FLBuilt 1979 · S/N 18266826N27AMThom Jacob D · Wasilla, AKBuilt 1990 · S/N 001AMN27AUAndrews University · Berrien Springs, MIBuilt 2014 · S/N 2843768N27AZGilbert John K · Austin, TXBuilt 2022 · S/N 1217N27BSl Leasing Group LLC · Barnesville, GABuilt 1975 · S/N 21061108N27BEAir N Nautical LLC · Kalispell, MTBuilt 1998 · S/N 1418N27BGGuzman Steven Manuel · Port Saint Lucie, FLS/N 340A0656N27BLFairmont State University · Fairmont, WVBuilt 2020 · S/N 172S12467N27BSBlackhawk 787 LLC · Columbus, OHBuilt 2016 · S/N 14027N27CMM & J Enterprises · Union, SCBuilt 1979 · S/N 571N27CYSale Reported · Hastings, FLSale reportedBuilt 1976 · S/N 27-7654118N27DASiewruk Cameron M · Stuart, FLBuilt 1978 · S/N 32-7840084N27DHMcavoy Sean M · Greenbrier, TNBuilt 1970 · S/N D-9149N27DQOhio University · Albany, OHBuilt 1972 · S/N TH-228N27DRN504fl LLC · Killeen, TXBuilt 2003 · S/N 24703N27DWFritschle Derek R · Olney, ILBuilt 1975 · S/N 94N27EGVetterman Larry D · Hot Springs, SDBuilt 2017 · S/N 062N27EKPrecision Aviation Training LLC · Newberg, ORBuilt 2022 · S/N 1311N27FCWalburn John M · Mansfield, OHBuilt 1962 · S/N 18254410N27GFAmerican Patrols Inc · Midland, TXBuilt 1981 · S/N 17274608N27GHNelson Aviation LLC · Chesterfield, MOBuilt 2017 · S/N 18283019N27GPFlying Colors Airparts Inc · Leesburg, FLBuilt 1977 · S/N U20604105N27GSMazzola Michael · Baton Rouge, LABuilt 1977 · S/N 28R-7737160N27GWWatson Gary R · Modesto, CABuilt 1982 · S/N 0002N27GZKelly Kristofor · Belton, TXBuilt 2000 · S/N 01N27HALmn Aircraft Leasing LLC · Sellersburg, INBuilt 1982 · S/N T30300064N27HBBalk Christopher T · Arlington, WABuilt 1977 · S/N E-999N27HCCranston Courtland L · Santa Rosa, CAS/N 1N27HPTrinair Aviation LLC · Hampshire, ILBuilt 1962 · S/N 27-2034N27HRRemer Herbert I · Punta Gorda, FLBuilt 1999 · S/N 1444N27HTTaylor Arthur W · Oswego, NYBuilt 2020 · S/N 20685N27HUOlson Dorian J · Lake Park, MNBuilt 1997 · S/N 1359N27HWJacobs Jim · Great Barrington, MABuilt 2018 · S/N 1177-2018N27HYMiand Inc · Laporte, INBuilt 1999 · S/N 1457N27JOliver Paul D · Hedgesville, WVBuilt 1989 · S/N 1N27JCTalotta Nicholas J · Ocean City, NJBuilt 1960 · S/N CD-267N27JPWillis Roger · Bellview, FLS/N 39129N27JWGaither William W · Shallotte, NCS/N 17701148N27KHume James W · Valley View, TXBuilt 1987 · S/N 1067AN27KKButler Robert Wynne Jr · Boyce, LABuilt 1962 · S/N 28-792N27KPMcgaughey Patrick L · Los Alamos, NMBuilt 2007 · S/N 22066N27LASouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1975 · S/N 17265689N27LEQuality Feed Grains · Harrison, ARBuilt 2000 · S/N 00-301030
Back to AD 2007-04-19 R1