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.

N3195ZMcgrady Chadwick Paxton · Glade Park, COBuilt 1959 · S/N 18-7191N31969Chandelle Flying Club Inc. · Austin, TXBuilt 1978 · S/N 28-7890488N3196AKloker Daniel E · Owasso, OKBuilt 1994 · S/N E-2885N3196CWeir Ryan L · Buckley, WABuilt 1954 · S/N 30995N3196RS & S Aviation Co · Ball Ground, GAS/N 18258596N3196SHistoricair Transport LLC · Midlothian, TXS/N 18255696N3196TNicholson Perry R · Merlin, ORBuilt 1968 · S/N 17700496N3196WTs Aviation LLC · Sioux Falls, SDBuilt 1999 · S/N TH-1913N3196YRickles Richard J · Chamblee, GABuilt 1962 · S/N 18254196N31977Wedekemper Donald E · Howell, MIBuilt 1978 · S/N 32R-7885148N3197CScott James D · Mesa, AZBuilt 1954 · S/N 30996N3197FWhite River Land And Timber Co LLC · Greenbrier, ARBuilt 1966 · S/N 18257297N3197MBonanza Five Flying Club Inc · Roswell, GABuilt 1994 · S/N E-2887N3197SJarvis Jason O · Cresson, TXBuilt 1964 · S/N 18255697N3197TMundle Jeffrey A · Ashland, ORBuilt 1967 · S/N 17700497N3197YMonahan Robert J · Bulverde, TXBuilt 1962 · S/N 18254197N3197ZSlayden Steven M · Rhome, TXBuilt 1959 · S/N 18-7195N31985Ledge Aero Inc · Holt, MIBuilt 1978 · S/N 28-7816604N31988Little Dog Aviation LLC · Branchburg, NJBuilt 1978 · S/N 28-7816605N3198FDepinet Rodney J · Glen Saint Mary, FLBuilt 1968 · S/N 17256588N3198LKatsahnias George T · Denton, TXBuilt 1994 · S/N E-2898N3198WRobert And Donna Odegaard Family Lllp II · Kindred, NDBuilt 1974 · S/N TC-1647N3198YKembel Cary A · Snyder, COBuilt 1962 · S/N 18254198N31995One Zero Tango LLC · Chattanooga, TNBuilt 1978 · S/N 32R-7885149N31996Seacoast Plane Partners LLC · Exeter, NHBuilt 1978 · S/N 32R-7885151N3199CGreenleaf Michael G · Tacoma, WAFirst renewal noticeBuilt 1954 · S/N 30998N3199DHebda Thomas W · Colorado Springs, COBuilt 1994 · S/N EA-566N3199GDriftless Aviation LLC · Wilmington, DEBuilt 1994 · S/N E-2890N3199HHills Holding · Newark, DEBuilt 1994 · S/N E-2891N3199JSietsma Lawrence F · Indialantic, FLBuilt 1999 · S/N TH-1899N3199RUmina Michael P · Hopkinton, MABuilt 1967 · S/N 18258599N3199TMortgage Experts LLC · Homestead, FLBuilt 1967 · S/N 17700499N3199UNiner Niner Uniform LLC · Elk Mound, WIBuilt 1963 · S/N 18254599N3199WCoastal Sky Partners LLC · Wilmington, DEBuilt 1974 · S/N TC-1648N3199YClearwater Valley Aero Club Inc · Kamiah, IDBuilt 1962 · S/N 18254199N319AMJones Arthur L · Bend, ORBuilt 2005 · S/N 2319N319AUChristiansen Aviation LLC · Wilmington, DEBuilt 2024 · S/N 4496585N319AZRegistered aircraftBuilt 1988 · S/N 1850N319CAAcree James · Euless, TXS/N TK93N319CBBoyer Richard · Georgetown, TXBuilt 2010 · S/N 40441N319CCYale Companies LLC DBA · Indianapolis, INBuilt 2021 · S/N 2881505N319DCBecker Dennis P · Kelso, WABuilt 2008 · S/N 23772N319ECRansom Robert W · Moorestown, NJBuilt 1994 · S/N 19032CN319EGVertx Fleet Holdings LLC · San Diego, CABuilt 2021 · S/N 28020021N319EPEpic Aviation Inc · New Smyrna, FLBuilt 2019 · S/N 172S12277N319FTPerez Guillermo T · Castaic, CABuilt 1982 · S/N 28-8216208N319GSilver Star Holdings LLC · Aurora, COBuilt 2002 · S/N 0319N319GHHalverson Gregory W · Portland, ORBuilt 2007 · S/N 21111N319GKKonrad Gary T · Howell, MIBuilt 2019 · S/N 70093N319GRGuinn John F · Baxter, TNBuilt 1978 · S/N M-2080
Back to AD 2007-04-19 R1