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.

N52749Middle Tennessee State University · Murfreesboro, TNS/N 17274599N5274DSimonsen Deanne M · White Salmon, WABuilt 1958 · S/N 50172N5274EFedermann Joe R · Anchorage, AKBuilt 1959 · S/N 50574N5274HLincoln Skyways Inc · Lincoln, CABuilt 1975 · S/N 17265392N5274LRetzer Daniel R · Rockford, ILBuilt 1967 · S/N 28-4573N5274SHap'S Air Inc · Ames, IABuilt 1980 · S/N R18201534N5274VH & R Aviation LLC · West Linn, ORBuilt 2009 · S/N 172S11005N5274XStallings Aircraft Propeller LLC · Wynne, ARBuilt 1969 · S/N 176N5274YMba Sales LLC · Ridgefield, WABuilt 1980 · S/N 21064147N52750Wieneke Robert A · Rockwall, TXBuilt 1981 · S/N 17274600N52751Weinstein Mark H · Carrollton, GABuilt 1974 · S/N 18262819N52753Omark Aviation LLC · Naples, FLBuilt 2002 · S/N 18281164N52754Torgerson'S LLC · Ethridge, MTBuilt 1974 · S/N 18262822N52756Fowler Jon E · Cal Nev Ari, NVBuilt 1943 · S/N 245N52757Brady Aviation Ltd Co · Friendswood, TXBuilt 2002 · S/N 18281165N52758Luse David C · Newalla, OKBuilt 1974 · S/N 18262825N5275DWorrell Sharyl L · Anchorage, AKBuilt 1958 · S/N 50173N5275EPasiewicz Shannon M · Anchorage, AKBuilt 1959 · S/N 50575N5275GMccarley Kendel M · Tucson, AZS/N 38031N5275RNorth Matthew E · Oro Valley, AZBuilt 1978 · S/N R18200641N5275S75s Leasing LLC · Greenwood Village, COBuilt 2002 · S/N 172S9203N5275VViatrans LLC · Pryor, OKBuilt 1975 · S/N 21060890N5275WMustang Sally Aviation LLC · Camden, SCS/N 172S10938N5275XKirschner David R · Mckeesport, PABuilt 1969 · S/N 177N52761Reb Baron Aviation LLC · Riverdale, CAS/N 18262828N52764Skylane LLC · Williamsburg, VABuilt 1974 · S/N 18262831N52767Loudy William E · Rigby, IDBuilt 1974 · S/N 18262834N5276AOstermeier Brigitte · MaunNon-citizen corporation, flight hours not reportedBuilt 1979 · S/N 21063341N5276ESchmutz George L · Atascadero, CABuilt 1983 · S/N 18268306N5276LHaynie Sidney S · Sedona, AZBuilt 1968 · S/N 28-4575N5276PBellers Aviation Inc · Fremont, CABuilt 2009 · S/N 172S11010N5276VSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1975 · S/N 21060891N5276WThird Step 2 LLC · Wilmington, DEFirst renewal noticeBuilt 1962 · S/N 28-323N5276XSanders Curtis E · Morrison, MOBuilt 1969 · S/N 212N52775Pa-18 LLC · Hood River, ORBuilt 1974 · S/N 18262837N5277GRussell Michael E · Sumner, TXBuilt 1950 · S/N 22134N5277JYr-Aircraft Leasing LLC · Bethel, AKBuilt 1984 · S/N 20700772N5277PBennett Glenn D · Kingwood, TXBuilt 1977 · S/N 21061784N5277SFers Mitchell A · Stafford Springs, CTBuilt 1970 · S/N 28-26908N5277VLechner Gary D · Woodstock, ILBuilt 1975 · S/N 21060892N5277WPerkins Nathan Zachery · Bonanza, ORBuilt 1962 · S/N 28-325N52781Mckendry Martin · Carmel Valley, CABuilt 1974 · S/N 18262840N52783Valdes Alfonso · El Paso, TXBuilt 1974 · S/N 18262842N52789Alameda Aero Club · Alameda, CABuilt 1981 · S/N 17274607N5278DN5278d LLC · Dover, DEBuilt 1979 · S/N 17272488N5278ESeasholtz John O · Fresno, CABuilt 1979 · S/N 18503949N5278GCostilow Bobby W · Griffin, GAS/N 22732N5278PRoebuck David M · Hamilton, GABuilt 1958 · S/N 24-317N5278RHussain Mahmoud Taimour Said · Miami, FLBuilt 1974 · S/N 17263492N5278SN5278s LLC · Katy, TXBuilt 1970 · S/N 28-26911
Back to AD 2007-04-19 R1